RE: Oracle Performance

From: Whittle Jerome Contr NCI <Jerome.Whittle_at_scott.af.mil>
Date: Thu, 11 Mar 2004 14:43:43 -0600
Message-ID: <DFEC3C69DE8C524DA705BC09A220740B029CB048@AMCW2VN801.amc.ds.af.mil>

Maybe I wasn't clear enough. I use the Rule hint for troubleshooting. If it works much faster with the Rule hint, obviously something else needs investigating like analyzing tables or using histograms. If using Rule is slower, that also gives me some ideas. If using Rule doesn't make any difference and the SQL is still slow, maybe there needs to be an index or some other way of writing the SQL.

Using the Rule hint is a good, quick troubleshooting method but not normally the fix.

Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
jerome.whittle_at_scott.af.mil
618-622-4145

> -----Original Message-----
> From: Juan Cachito Reyes Pacheco [SMTP:jreyes_at_dazasoftware.com]
>
> Honestly I don't agree with this, I don't think there is any need to use rule, in Oracle 9i, CBO works
> perfectly with this kind of situation, the problem must be find and fixed.
>
> ----- Original Message -----
> From: Whittle Jerome Contr NCI <mailto:Jerome.Whittle_at_scott.af.mil>
>
> You have 5 indexes of which 3 have the fields in your SQL. You may be better off with one index on the COD_IMPORTACION, COD_NIVEL_CALIDAD, and NRO_FACTURACION fields. After creating the index, analyze the table before running your sql.
>
> You might also just want to try to use the Rule hint. It's usually one of the first things I try with slow SQL. If it runs much faster with the Rule hint, something is going on to confuse the CBO.
>
> SELECT /*+ RULE */ COUNT(NRO_FACTURACION) ....
>
> Jerry Whittle
> ASIFICS DBA
> NCI Information Systems Inc.
> jerome.whittle_at_scott.af.mil
> 618-622-4145

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Mar 11 2004 - 17:13:56 CST