DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 16

Thread: sql query tuning

Threaded View

  1. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Hrishy ;

    Try this....i am not sure....coz never touched the performance manual yet...

    SQL> SELECT
    ttralnktix.CODAPP_OLD,
    2 ttralnktix.NUMTRAFRT,
    3 TPTFBDR_B.CODPTF codptfold ,
    4 ttralnktix.NUMTRAFRTLNK,
    5 ttralnktix.CODAPP_NEW,
    6 TPTFBDR_A.CODPTF codptfnew,
    7 ttralnktix.CURDATE
    8 FROM ttralnktix,
    9 TPTFBDR TPTFBDR_A,
    10 TPARCPTTIX TPARCPTTIX_A,
    11 TPARGESTIX TPARGESTIX_A,
    12 TPTFBDR TPTFBDR_B,
    13 TPARCPTTIX TPARCPTTIX_B,
    14 TPARGESTIX TPARGESTIX_B
    15 WHERE ( ( TPARCPTTIX_B.IDFTRA = TPARGESTIX_B.IDFTRA ) and
    16 ( TPARCPTTIX_A.IDFTRA = TPARGESTIX_A.IDFTRA ) and
    17 ( ttralnktix.NUMTRAFRT = TPARGESTIX_A.NUMTRAFRT ) AND
    18 ( TPARCPTTIX_B.CODTRSPTF = TPTFBDR_B.CODTRS ) AND
    19 ( ttralnktix.NUMTRAFRTLNK = TPARGESTIX_B.NUMTRAFRT ) AND
    20 ( TPARCPTTIX_A.CODTRSPTF = TPTFBDR_A.CODTRS ) AND
    21 ( ttralnktix.CODAPP_OLD = TPARGESTIX_A.CODAPPFRT ) AND
    22 ( ttralnktix.CODAPP_NEW = TPARGESTIX_B.CODAPPFRT )
    23 AND
    24 ( TPTFBDR_B.CODPTF = 'WARTS') ) ;
    25 ;

    Abhay
    Last edited by abhaysk; 04-10-2003 at 11:43 PM.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width