469,612 Members | 1,605 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

confusion about cardinality in explain plan node on compressed table

hello,

I have compressed table 442992 rows and when i run explain plan on
this table for some SQL using this table, i see table scan and
cardinality on top of table node as 18458. I am new to compression and
do not understand why cardinality is not the actual number of rows but
18458.
look below at table ABC.XYZ

672
BTQ
( 30)
122.764
99
|
28
TBSCAN
( 31)
122.507
99
|
18458
TABLE: ABC
XYZ

Oct 21 '08 #1
2 4278
Ian
db2admin wrote:
hello,

I have compressed table 442992 rows and when i run explain plan on
this table for some SQL using this table, i see table scan and
cardinality on top of table node as 18458. I am new to compression and
do not understand why cardinality is not the actual number of rows but
18458.
look below at table ABC.XYZ

672
BTQ
( 30)
122.764
99
|
28
TBSCAN
( 31)
122.507
99
|
18458
TABLE: ABC
XYZ
This has nothing to do with compression. You are running with DPF, and
ABC.XYZ has 24 partitions.

The TBSCAN (31) happens on each data partition -- each data partition
should have approximately 1/24 of the data.

Oct 21 '08 #2
On Oct 21, 1:18*pm, Ian <ianb...@mobileaudio.comwrote:
db2admin wrote:
hello,
I have compressed table 442992 rows and when i run explain plan on
this table for some SQL using this table, i see table scan and
cardinality on top of table node as 18458. I am new to compression and
do not understand why cardinality is not the actual number of rows but
18458.
look below at table ABC.XYZ
* * * 672
* * BTQ
* * ( *30)
* * 122.764
* * * 99
* * * |
* * * 28
* * TBSCAN
* * ( *31)
* * 122.507
* * * 99
* * * |
* * *18458
TABLE: ABC
* *XYZ

This has nothing to do with compression. *You are running with DPF, and
ABC.XYZ has 24 partitions.

The TBSCAN (31) happens on each data partition -- each data partition
should have approximately 1/24 of the data.
yes
thankyou
how did i miss that one
Oct 21 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Rizyak | last post: by
14 posts views Thread by Ina Schmitz | last post: by
reply views Thread by JAW | 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.