************************************
very slow plan
Access Plan:
-----------
Total Cost: 1654,31
Query Degree: 1
16393,6
FETCH
( 9)
997,374
456,051
/----+---\
16393,6 101953
RIDSCN TABLE: DB2ADMIN
( 10) SY0001_00005
271,381
72,7273
+-----------------+-----------------+-------- (breaked to next
line!!!)
2,56582e-008 1,4073e-006 0,00508163
SORT SORT SORT
( 11) ( 13) ( 15)
12,8875 12,8875 12,8808
1 1 1
| | |
2,56582e-008 1,4073e-006 0,00508163
IXSCAN IXSCAN IXSCAN
( 12) ( 14) ( 16)
12,8867 12,8867 12,88
1 1 1
| | |
101953 101953 101953
INDEX: SYSIBM INDEX: SYSIBM INDEX: SYSIBM
SQL0505311306228 SQL0505311306228 SQL0505311306228
-+-------+-----------------+-----------------+
4,3295 213,774 16210,2
SORT SORT SORT
( 17) ( 19) ( 21)
12,883 13,0273 206,819
1 1 67,7273
| | |
4,3295 213,774 16210,2
IXSCAN IXSCAN IXSCAN
( 18) ( 20) ( 22)
12,8822 12,9791 199,147
1 1 67,7273
| | |
101953 101953 101953
INDEX: SYSIBM INDEX: SYSIBM INDEX: DB2ADMIN
SQL0505311306228 SQL0505311306228 SY0001_00005_KEY
************************************************** ***************************
Can anyone help me!
Thanks!
Marc