Re: Statistics used by optimizer.
Posted by:
Rick James
Date: September 04, 2009 07:37PM
And I will give you "one more" answer... ;)
Well, only a guess. The filter percentage is a new feature, and I don't have much feel for it yet. Perhaps an early stage in the optimizer decided that it would be more than 30% and then simply set a value (50%) to tell the next stage of the optimizer "don't use the index" but also "you won't need all the rows". It could be that some query would then turn around and use the index anyway. And maybe it is useful to know that not all of the table will be used. (Granted, the 50% does not tell us much.)
Subject
Views
Written By
Posted
6363
August 28, 2009 07:32AM
2645
August 29, 2009 01:11PM
2498
September 01, 2009 06:30AM
2450
September 01, 2009 07:44AM
2477
September 01, 2009 02:51PM
2278
September 01, 2009 09:59PM
2409
September 04, 2009 11:00AM
Re: Statistics used by optimizer.
2405
September 04, 2009 07:37PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.