Re: Using index makes query slower than table scan
I agree Daniel.
I just found the article.
The rule of thumb is: If a request returns more then 20% of the request its faster to do a full table scan.
If its less than 0.5% an index access is faster.
In between this range other factors hve to be looked at.
Hubble
Subject
Views
Written By
Posted
2379
October 25, 2005 07:36AM
1418
October 26, 2005 02:26AM
1462
October 26, 2005 04:46AM
1410
October 26, 2005 08:45AM
1514
October 26, 2005 02:14PM
1849
October 26, 2005 02:48PM
Re: Using index makes query slower than table scan
1582
October 27, 2005 03:47AM
1555
October 31, 2005 07:07AM
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.