Hi,
Can someone shed some light on the differences of gathering statistics on a
function-based index using the following two methods?
method 1: analyze table table_name compute statistics
vs
method 2: create unique index index_name on table_name
(upper(columne_name)) compute statistics;
I could
someone shed some light on the differences of gathering statistics on a
function-based index using the following two methods?
method 1: analyze table table_name compute statistics
vs
method 2: create unique index index_name on table_name
(upper(columne_name)) compute statistics;
I could not get
to list
the contents of user_indexes for the index after each of the analyzes?
At 05:45 AM 6/2/2003 -0800, you wrote:
Hi,
Can someone shed some light on the differences of gathering statistics on
a function-based index using the following two methods?
method 1: analyze table table_name compute
Breitling [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Gathering statistics on function-based index
Date: Mon, 02 Jun 2003 07:30:07 -0800
Have you tried methods 3 or preferrably method 4:
method 3: analyze index index_name compute