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 ?.
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 -----------------------------------------------------------------Received on Tue Jul 13 2004 - 10:12:39 CDT
![]() |
![]() |