hints expression oracle 9.0 in Powerbuilder 9.0

Hello cheers to all.

I got this sql from Orable 9.0, we need to put a hint expression in this sql
to improve the performance on the execution of the sql, well i dont know if
this run fine in sql embeded, because this expression use /* */ operator,
like the following example. In powerbuilde these operators are used to
put comments in the script..

SELECT /* + INDEX ("CB_MOV_PAG" "CB_MOV_PAG1") */
 sum ("CB_MOV_DET"."MON_PAG")
    FROM "CB_MOV_DET",
         "CB_MOV_PAG"
   WHERE ( "CB_MOV_DET"."COD_CIA" = "CB_MOV_PAG"."COD_CIA" ) and
         ( "CB_MOV_DET"."COD_TAQ" = "CB_MOV_PAG"."COD_TAQ" ) and
         ( "CB_MOV_DET"."NUM_CAJ" = "CB_MOV_PAG"."NUM_CAJ" ) and
         ( "CB_MOV_DET"."NRO_TRA" = "CB_MOV_PAG"."NRO_TRA" ) and
         ( "CB_MOV_DET"."CIA_REC" = "CB_MOV_PAG"."CIA_REC" ) and
         ( "CB_MOV_DET"."TAQ_REC" = "CB_MOV_PAG"."TAQ_REC" ) and
         ( ( "CB_MOV_DET"."NUM_CAJ" = 1 ) AND
         ( "CB_MOV_DET"."CIA_REC" = 1 ) AND
         ( "CB_MOV_DET"."TAQ_REC" = 1 ) AND
         ( "CB_MOV_DET"."TIP_INS" = 1 ) AND
         ( trunc("CB_MOV_PAG"."FEC_CRE") >= TO_TIMESTAMP('01-01-2004
00:00','DD-MM-YYYY HH24:MI:SS')  ) AND
         ( "CB_MOV_DET"."ID_CLI" >= 0 ) AND
         ( "CB_MOV_DET"."NUM_DOC" >= 0 ) AND
         ( "CB_MOV_DET"."GRP_CON" >= 0 ) AND
         ( "CB_MOV_DET"."COD_CON" >= 0 )
          )
I need someone who can give an advise about this and how can use hints in
sql embeded inside Powerbuilder.


Thanks in advance
from Venezuela
Eduardo Primera



0
eprimera
3/9/2005 5:18:40 PM
sybase.powerbuilder.database 9855 articles. 1 followers. Follow

1 Replies
751 Views

Similar Articles

[PageSpeed] 50

Yes, I believe that PB will treat it as a comment.  I know of no way around
it in embedded SQL.  I'm sure if I am wrong, someone will point it out. :-)

However, you could place the query into a datawindow object, associate it to
a datastore, and do the retrieval that way.  When passed as contained in the
SQL within a datawindow object, the hint will be sent to Oracle.  We do that
all of the time.

Richard

"eprimera" <primera_ps@yaho.com> wrote in message
news:422f2ff0@forums-1-dub...
> Hello cheers to all.
>
> I got this sql from Orable 9.0, we need to put a hint expression in this
sql
> to improve the performance on the execution of the sql, well i dont know
if
> this run fine in sql embeded, because this expression use /* */ operator,
> like the following example. In powerbuilde these operators are used to
> put comments in the script..
>
> SELECT /* + INDEX ("CB_MOV_PAG" "CB_MOV_PAG1") */
>  sum ("CB_MOV_DET"."MON_PAG")
>     FROM "CB_MOV_DET",
>          "CB_MOV_PAG"
>    WHERE ( "CB_MOV_DET"."COD_CIA" = "CB_MOV_PAG"."COD_CIA" ) and
>          ( "CB_MOV_DET"."COD_TAQ" = "CB_MOV_PAG"."COD_TAQ" ) and
>          ( "CB_MOV_DET"."NUM_CAJ" = "CB_MOV_PAG"."NUM_CAJ" ) and
>          ( "CB_MOV_DET"."NRO_TRA" = "CB_MOV_PAG"."NRO_TRA" ) and
>          ( "CB_MOV_DET"."CIA_REC" = "CB_MOV_PAG"."CIA_REC" ) and
>          ( "CB_MOV_DET"."TAQ_REC" = "CB_MOV_PAG"."TAQ_REC" ) and
>          ( ( "CB_MOV_DET"."NUM_CAJ" = 1 ) AND
>          ( "CB_MOV_DET"."CIA_REC" = 1 ) AND
>          ( "CB_MOV_DET"."TAQ_REC" = 1 ) AND
>          ( "CB_MOV_DET"."TIP_INS" = 1 ) AND
>          ( trunc("CB_MOV_PAG"."FEC_CRE") >= TO_TIMESTAMP('01-01-2004
> 00:00','DD-MM-YYYY HH24:MI:SS')  ) AND
>          ( "CB_MOV_DET"."ID_CLI" >= 0 ) AND
>          ( "CB_MOV_DET"."NUM_DOC" >= 0 ) AND
>          ( "CB_MOV_DET"."GRP_CON" >= 0 ) AND
>          ( "CB_MOV_DET"."COD_CON" >= 0 )
>           )
> I need someone who can give an advise about this and how can use hints in
> sql embeded inside Powerbuilder.
>
>
> Thanks in advance
> from Venezuela
> Eduardo Primera
>
>
>


0
Rich
3/9/2005 7:43:22 PM
Reply:

Web resources about - hints expression oracle 9.0 in Powerbuilder 9.0 - sybase.powerbuilder.database

PowerBuilder - Wikipedia, the free encyclopedia
PowerBuilder is an integrated development environment owned by Sybase , a division of SAP . It has been in use since 1991, peaking around 1998 ...

Sybase PowerBuilder tool readied for Microsoft's .Net
... Win32 or newer style .Net development After several years of work, Sybase is ready to deliver on the final step in its plan to move PowerBuilder ...

Jim O'Neil (@jimoneil) on Twitter
Sign in Sign up To bring you Twitter, we and our partners use cookies on our and other websites. Cookies help personalize Twitter content, tailor ...

Open Directory - Computers: Programming: Languages
about dmoz - dmoz blog - report abuse/spam - help the entire directory only in Programming/Languages Description Top : Computers : Programming ...

The HP Booth Staff (Goons) Owe Me an Apology
... when you might need to use it. For instance, when I was in the WinRunner world there were plugins for driving terminal emulators and powerbuilder ...

Contact Us - Sybase Inc
Thanks for visiting the 主页 section of Sybase.com. Here you will find information about Contact Us. For more information about Business Intelligence, ...

热门搜索 - 我的异常网
... 我的异常网 » 热门搜索 sdpnet2 移动【A111】其它用户原因鉴权失败,是什么意思啊 http:// 192.168.1.102:22578 本网站服务器位于美国,受美国法律保护 MiniUI js 破解 http://192.168.1.103:8080/ powerbuilder ...

Mobile app security: Always keep the back door locked
The best way to keep mobile apps safe is to secure the services they connect to.

10 Tech Skills That Will Instantly Net You A $100,000+ Salary
... that let's developers run Java applications. Java is highly popular language for writing web apps and custom enterprise apps. No. 8: PowerBuilder ...

Top Ranked Articles
Top Ranked Articles - Free source code and tutorials for Software developers and Architects.; Updated: 23 Feb 2013

Resources last updated: 1/4/2016 10:44:52 PM