Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Index Usage ?!

Re: Index Usage ?!

From: Prem Khanna J <jprem_at_kssnet.co.jp>
Date: Fri, 25 Jul 2003 20:22:55 +0900
Message-Id: <26013.339592@fatcity.com>


Thanx a lot Irfan.
let me also go thro' metalink and try out something.

Regards,
Jp.

25-07-2003 18:46:51, Irfan Khan <irfan.khan_at_converge.com> wrote:
>From what i understand when u analyze , use the keyword of size to set the
>histogram buckets
>Generally it should be no of distinct values in a column + som ball park no.
>say ten.
>U can play around with this analyzing with histograms.
>I tried and it worked for me and so it should for you as well.
>I will do more research and will get back to you.
>Irfan , Khan
Received on Fri Jul 25 2003 - 06:22:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US