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