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. for eg: Select ... where A.ID = ... and A.Name = ... The Key order on this table A NOW is Name & ID Order . Shouldn't they be in the order ID , Name ?.. #2) Can anybody recommend me any site , where I will get reliable information on Tuning PL/SQL ?. With thanks in advance Ranjeesh ---------------------------------------------------------------- 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 -----------------------------------------------------------------