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 

--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

Re: Too many rows reported for index in tkprof
From: Leandro Guimaraes Faria C. Dutra

References:
- Too many rows reported for index in tkprof
  - From: Leandro Guimaraes Faria C. Dutra

Re: Too many rows reported for index in tkprof

Other related posts: