index selectivity when histograms presents on the column
- From: "The Human Fly" <sjaffarhussain@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 21 Mar 2006 18:57:54 +0300
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."
--
http://www.freelists.org/webpage/oracle-l
- Follow-Ups:
- Re: index selectivity when histograms presents on the column
- From: Jared Still
Other related posts:
- » index selectivity when histograms presents on the column
- » Re: index selectivity when histograms presents on the column
- Re: index selectivity when histograms presents on the column
- From: Jared Still