Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Index Usage ?!
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
![]() |
![]() |