Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Analyze Indexes vs. Table

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)?</font></font>&nbsp;<font face="Arial"><font size=-1>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.</font></font>&nbsp;<font face="Arial"><font size=-1>What are your opinions and experiences?</font></font>&nbsp;<font face="Arial"><font size=-1>Thanks very much for the feedback.</font></font><font face="Arial"><font size=-1>-w</font></font></blockquote>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US