Re: index usage

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Thu, 20 Jan 2005 20:57:23 -0000
Message-ID: <41f01b1e$0$16583$cc9e4d1f@news-text.dial.pipex.com>

"Richard Foote" <richard.foote_at_bigpond.nospam.com> wrote in message news:fJMHd.126019$K7.84069_at_news-server.bigpond.net.au...
> I can easily give you an example where an index is most efficient when
> reading 0% of data

snip all the rest of the good stuff to say

welcome back. and
er, wouldnt not executing the query at all be more efficient in the 0% case?

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com

Received on Thu Jan 20 2005 - 14:57:23 CST