469,648 Members | 1,504 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,648 developers. It's quick & easy.

db2expln output and operator information

Colleagues:

Can anyone tell me what the number to the right of "Index Prefetch:
Eligible" designates in the output from db2expln, e.g., "Index
Prefetch: Eligible 14409"?

I see such a number in many examples of dynexpln output on the web, but
can only find explanations such as this one, which lacks any mention of
the number:

The following statement indicates that index pages should be
prefetched:

Index Prefetch: Eligible

--Jeff

Nov 3 '06 #1
1 2663
I answered my own question. Cross referencing the output of db2expln
with that of Visual Explain shows that this number "[i]ndicates how
many pages are expected to be read" by the prefetch operation.

--Jeff

jefftyzzer wrote:
Colleagues:

Can anyone tell me what the number to the right of "Index Prefetch:
Eligible" designates in the output from db2expln, e.g., "Index
Prefetch: Eligible 14409"?

I see such a number in many examples of dynexpln output on the web, but
can only find explanations such as this one, which lacks any mention of
the number:

The following statement indicates that index pages should be
prefetched:

Index Prefetch: Eligible

--Jeff
Nov 4 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by APAPF | last post: by
2 posts views Thread by LazyAnt | last post: by
3 posts views Thread by Terry | last post: by
10 posts views Thread by Johannes Barop | last post: by
4 posts views Thread by tuarek | last post: by
1 post views Thread by Troels Arvin | last post: by
6 posts views Thread by Jojo | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.