Re: index selection!

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 9 Sep 2000 19:02:42 +0100
Message-ID: <968522928.12699.0.nnrp-08.9e984b29@news.demon.co.uk>

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!

>

Received on Sat Sep 09 2000 - 13:02:42 CDT