From: "Jonathan Lewis" <jonathan@jlcomp.demon.co.uk>
Newsgroups: comp.databases.oracle.server
Subject: Re: index selection!
Date: Sat, 9 Sep 2000 19:02:42 +0100
Message-ID: <968522928.12699.0.nnrp-08.9e984b29@news.demon.co.uk>
References: <8p9i97$8f7$1@nnrp1.deja.com> <8p9l9g$c15$1@nnrp1.deja.com> <8pc86s$c9c$1@nnrp1.deja.com>
NNTP-Posting-Host: jlcomp.demon.co.uk
X-NNTP-Posting-Host: jlcomp.demon.co.uk:158.152.75.41
X-Trace: news.demon.co.uk 968522928 nnrp-08:12699 NO-IDENT jlcomp.demon.co.uk:158.152.75.41
X-Complaints-To: abuse@demon.net
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Lines: 17


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!
>