RE: Composite Index Order VS Query Order ?? , Tuning Docs URL ?.
- From: "Cary Millsap" <cary.millsap@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 13 Jul 2004 11:20:15 -0500
>From experience, the best way to tune PL/SQL is to scrap everything and
>rewrite from scratch.
>Get rid of count(*) and cursors in loops for a start.
Yes! :)
I may have misinterpreted the poster's original question here. I =
answered
the name of a good SQL optimization book. If the issue is really PL/SQL
optimization, then you need to have three books in your library:
Kyte, T.: Expert Oracle One on One
Kyte, T.: Effective Oracle by Design
McDonald, C.; et al.: Mastering Oracle PL/SQL
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *
Upcoming events:
- Performance Diagnosis 101: 7/20 Cleveland, 8/10 Boston, 9/14 San =
Francisco
- SQL Optimization 101: 7/26 Washington DC, 8/16 Minneapolis, 9/20 =
Hartford
- Hotsos Symposium 2005: March 6-10 Dallas
- Visit www.hotsos.com for schedule details...
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Stephane Faroult
Sent: Tuesday, July 13, 2004 10:15 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Composite Index Order VS Query Order ?? , Tuning Docs URL =
?.
=20
Hi,
I was working on optimising a piece of code which was taking 10hrs + to
execute and all.So my queries are..
#1) Saw a table where the "order of query" on the table and the "order =
of
key"
are different . For faster results shouldn't they be in the same order.
NO.
#2) Can anybody recommend me any site , where I will get reliable
informationon Tuning PL/SQL ?.
>From experience, the best way to tune PL/SQL is to scrap everything and
rewrite from scratch.
Get rid of count(*) and cursors in loops for a start.
HTH
S Faroult
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
- » Composite Index Order VS Query Order ?? , Tuning Docs URL ?.
- » Re: Composite Index Order VS Query Order ?? , Tuning Docs URL ?.
- » RE: Composite Index Order VS Query Order ?? , Tuning Docs URL ?.
- » RE: Composite Index Order VS Query Order ?? , Tuning Docs URL ?.
- » Re: Composite Index Order VS Query Order ?? , Tuning Docs URL ?.
- » Re: Composite Index Order VS Query Order ?? , Tuning Docs URL ?.
- » RE: Composite Index Order VS Query Order ?? , Tuning Docs URL ?.
- » Re: Composite Index Order VS Query Order ?? , Tuning Docs URL ?.
- » RE: Composite Index Order VS Query Order ?? , Tuning Docs URL ?.
- » RE: Composite Index Order VS Query Order ?? , Tuning Docs URL ?.
