index usage

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