sql query tuning

[hrishy]

Hi

Solved thsi by creating a index on ttralnktix.NUMTRAFRTLNK

0 SELECT STATEMENT Optimizer=CHOOSE
1 0 NESTED LOOPS
2 1 NESTED LOOPS
3 2 NESTED LOOPS
4 3 NESTED LOOPS
5 4 NESTED LOOPS
6 5 NESTED LOOPS
7 6 TABLE ACCESS (BY INDEX ROWID) OF 'TPTFBDR'
8 7 INDEX (UNIQUE SCAN) OF 'IPTFBDR2' (UNIQUE)
9 6 TABLE ACCESS (BY INDEX ROWID) OF 'TPARCPTTIX'
10 9 INDEX (RANGE SCAN) OF 'IPARCPTTIX2' (NON-UNI
QUE)

11 5 TABLE ACCESS (BY INDEX ROWID) OF 'TPARGESTIX'
12 11 INDEX (RANGE SCAN) OF 'IPARGESTIX1' (UNIQUE)
13 4 TABLE ACCESS (BY INDEX ROWID) OF 'TTRALNKTIX'
14 13 INDEX (RANGE SCAN) OF 'I_NUMTRAFRTLNK' (NON-UNIQ
UE)

15 3 TABLE ACCESS (BY INDEX ROWID) OF 'TPARGESTIX'
16 15 INDEX (RANGE SCAN) OF 'IPARGESTIX2' (NON-UNIQUE)
17 2 TABLE ACCESS (BY INDEX ROWID) OF 'TPARCPTTIX'
18 17 INDEX (RANGE SCAN) OF 'IPARCPTTIX1' (UNIQUE)
19 1 TABLE ACCESS (BY INDEX ROWID) OF 'TPTFBDR'
20 19 INDEX (UNIQUE SCAN) OF 'IPTFBDR1' (UNIQUE)




Statistics
----------------------------------------------------------
0 recursive calls
0 db block gets
1050 consistent gets
0 physical reads
136 redo size
1398 bytes sent via SQL*Net to client
554 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
6 rows processed

so abhay you still win the treat i guess :-)

regards
Hrishy