Re: index selection!

I cannot understand how this would help since if you do analyze table, it should create statistics for columns as well. Estimating might help since it should push the optimizer to an index based plan rather than full table scan. However I am kind of not sure whether it would create a full table scan path when you want it to.

analyze table mytable estimate statistics sample 10 percent ;

In article <968522928.12699.0.nnrp-08.9e984b29_at_news.demon.co.uk>,   "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
> The command you need is a variant of :
> analyze table xyz estimate statistics for columns tf_col;
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> wy_at_fudan.edu wrote in message <8pc86s$c9c$1_at_nnrp1.deja.com>...
> >I have run 'analyze table incard compute statistics'
> > and 'analyze index idx_bit_incard_if_chk compute statistics'
> >but it does not work!
> >
>
>

--
Ender Wiggin


Sent via Deja.com http://www.deja.com/
Before you buy.