| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Analyze Indexes vs. Table
This is a multi-part message in MIME format.
------=_NextPart_000_001C_01C017DA.89B69E90 Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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
------=_NextPart_000_001C_01C017DA.89B69E90 Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>What are the pros/cons of analyzing =
only the=20
indexes of a table versus analyzing the table (which will also analyze =
the=20
indexes)?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I'm asking this because I am using a =
data=20
extraction tool that does just this--it only analyzes the indexes of a =
table=20
rather than the table itself. This approach seems reasonable in theory =
but it=20
appears that it does not produce comparable execution paths. I have =
found that=20
unless I analyze the table, the execution path will not take advantage =
of a=20
bitmap index for a delete operation against the table.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>What are your opinions and=20
experiences?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks very much for the =
feedback.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>-w</FONT></DIV></BODY></HTML>
------=_NextPart_000_001C_01C017DA.89B69E90--
 |
 |