INDEX - row selectivity Vs block selectivity.
- From: Jaffar_DBA <sjaffarhussain@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 13 Dec 2004 18:18:55 +0300
Hello list,
I was reading an excellent paper written by Mr. Carry Millsap about
when to use indexes and I was very much interested to know more about
block selectivity. Could any one tell me more about how can we
estimate block selectivity for the index. It was there in the paper,
but, still I am confused. How can I used this method to evaluate to
use an index or not. At the beginning, table may contain little data
(few data blocks), later on, it could grow heavily. Then, do we have
to recalculate the formula again to make sure to use an index or not?
Thanking you in advance.
--
Best Regards,
Jaffar, OCP DBA
Banque Saudi Fransi
Saudi Arabia
--
//www.freelists.org/webpage/oracle-l
Other related posts:
