index usage - total no of records - doubt
hi, for Index can be used , if the table has how many records?
i.e for few records is is not useful right?
Not neccessarily. If you have a single record in a tabvle with its highwater mark at 8Mb then an index is going to be faster at finding it.
A table rebuild is nessesary in this case. Isn't it dave?
There are three kinds of lies: Lies, damned lies, and benchmarks...
Unix is user friendly. It's just very particular about who it's friends are.
If you are using CBO (Cost Based Optimizer) there is no way to know if an index is going to be used or not. Oracle will get statistics on data dictionary and based on this cost will let index to be used or not.
That's way Oracle is advising that RBO (Rule Based Optimizer) will be obsolete in further releases.
Just keep your database with statistics updated and you may have a good access plan.
Oracle Applications DBA
Click Here to Expand Forum to Full Width