A trivial, but important question is whether you
analyzed the index after creating it?
- "Leandro Guimaraes Faria C. Dutra"
<ldutra_at_toyota.com.br> wrote:
>
> Hi all.
>
> I'm fazed by a query I've been asked to
> optimize.
>
> By creating an index, I've been able to
> lower EXPLAIN's cost
> estimate from nearly 5k to 36. Problem is, this
> translated in an answer
> time reduced from 2min 30s to 2min 20s -- too small
> a reduction.
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 10 2005 - 12:18:43 CDT
