Re: Too many rows reported for index in tkprof
- From: Deepak Sharma <sharmakdeep_oracle@xxxxxxxxx>
- To: ldutra@xxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 10 Aug 2005 10:14:59 -0700 (PDT)
A trivial, but important question is whether you
analyzed the index after creating it?
--- "Leandro Guimaraes Faria C. Dutra"
<ldutra@xxxxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
