List, Can anyone tell me the index selectivity formula for a column when there are histograms on the column. I know that the index selectivity without histograms is = num_distinct/num_rows and also know that table selectivity uses density to calculate the selectivty when there are histograms placed on the column. Thanks, -- Best Regards, Syed Jaffar Hussain 8i,9i & 10g, OCP DBA Banque Saudi Fransi, Saudi Arabia http://jaffardba.blogspot.com/ ---------------------------------------------------------------------------------- "Winners don't do different things. They do things differently." -- //www.freelists.org/webpage/oracle-l