Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> index usage

index usage

From: hastenthunder <hastenthunder_at_hotmail.com>
Date: Wed, 19 Jan 2005 09:26:09 -0500
Message-ID: <56uHd.2452$Ny6.4229@mencken.net.nih.gov>


Hello,

I've read many documentations online stating to only create an index if queries against this table frequently retrieve less than 15% of the rows. However, if the query returns, say, 40% of the rows, wouldn't indexing the column still help by cutting the work by roughly half?

hastenthunder Received on Wed Jan 19 2005 - 08:26:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US