By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,586 Members | 2,347 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,586 IT Pros & Developers. It's quick & easy.

No Subject

P: n/a

************************************
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
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.