| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Composite Index Order VS Query Order ?? , Tuning Docs URL ?.
>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_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Stephane Faroult
Sent: Tuesday, July 13, 2004 10:15 AM
To: oracle-l_at_freelists.org
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
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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_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 Tue Jul 13 2004 - 11:20:10 CDT
 |
 |