Re: Analyze Indexes vs. Table

From: Joseph S. Testa <teci_at_oracle-dba.com>
Date: Wed, 06 Sep 2000 14:50:34 -0400
Message-Id: <10611.116329@fatcity.com>

--------------87639CAB24F6E70CA9EBBA95
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

most of my experience when you have mixed bag of tables and/or indexes where some are analyzed and others are not, Oracle seems to pick the WORST execution plan.

joe

Walter K wrote:

> What are the pros/cons of analyzing only the indexes of a table versus
> analyzing the table (which will also analyze the indexes)? I'm asking
> this because I am using a data extraction tool that does just this--it
> only analyzes the indexes of a table rather than the table itself.
> This approach seems reasonable in theory but it appears that it does
> not produce comparable execution paths. I have found that unless I
> analyze the table, the execution path will not take advantage of a
> bitmap index for a delete operation against the table. What are your
> opinions and experiences? Thanks very much for the feedback.-w

--------------87639CAB24F6E70CA9EBBA95
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">

<html>
<body bgcolor="#FFFFFF">
most of my experience when you have mixed bag of tables and/or indexes where some are analyzed and others are not, Oracle seems to pick the WORST execution plan.

<p>joe
<br>&nbsp;
<p>Walter K wrote:
<blockquote TYPE=CITE><style></style>
<font face="Arial"><font size=-1>What

are the pros/cons of analyzing only the indexes of a table versus analyzing the table (which will also analyze the indexes)? I'm asking this because I am using a data extraction tool that does just this--it only analyzes the indexes of a table rather than the table itself. This approach seems reasonable in theory but it appears that it does not produce comparable execution paths. I have found that unless I analyze the table, the execution path will not take advantage of a bitmap index for a delete operation against the table. What are your opinions and experiences? Thanks very much for the feedback.-w</blockquote>

</body>
</html> Received on Wed Sep 06 2000 - 13:50:34 CDT