From: EnderW <ender29@my-deja.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: index selection!
Date: Sun, 10 Sep 2000 03:43:25 GMT
Organization: Deja.com - Before you buy.
Lines: 33
Message-ID: <8pf00p$923$1@nnrp1.deja.com>
References: <8p9i97$8f7$1@nnrp1.deja.com> <8p9l9g$c15$1@nnrp1.deja.com> <8pc86s$c9c$1@nnrp1.deja.com> <968522928.12699.0.nnrp-08.9e984b29@news.demon.co.uk>
NNTP-Posting-Host: 24.128.210.239
X-Article-Creation-Date: Sun Sep 10 03:43:25 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.01; Windows 98; MSNIA)
X-Http-Proxy: 1.1 x71.deja.com:80 (Squid/1.1.22) for client 24.128.210.239
X-MyDeja-Info: XMYDJUIDender29


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@news.demon.co.uk>,
  "Jonathan Lewis" <jonathan@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@fudan.edu wrote in message <8pc86s$c9c$1@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.