Re: index scan is costly

From: <blundermaster_at_gmail.com>
Date: 6 Mar 2007 23:55:26 -0800
Message-ID: <1173254125.939517.203160@q40g2000cwq.googlegroups.com>

On your index_stats the LF_ROWS and DISTINCT_KEYS is "17705" but distinct record count on your table returns "25147". Are you experiening index corrupt? Try to rebuild the index or drop and recreate it again.

COUNT(DISTINCTPRODUCTID)

And also on your first post output of DBA_INDEX doesn't seems to have NUM_ROWS,DISTINCT_KEYS,LEAF_BLOCKS populated. I think your gather stats statement not gathering index statistics. Could you post the syntaxt that you using to gather statistics? Received on Wed Mar 07 2007 - 01:55:26 CST