I have got a Plan as below ----------------------------------------------------------------- | Operation | Name | ----------------------------------------------------------------- | SELECT STATEMENT | | | SORT UNIQUE | | | NESTED LOOPS | | | NESTED LOOPS | | | NESTED LOOPS | | | NESTED LOOPS | | | HASH JOIN | | | TABLE ACCESS FULL | KDD_BREAK_BINDING | | PARTITION RANGE ALL | | | TABLE ACCESS FULL | FIRM_ACCT_POSN | | TABLE ACCESS BY INDEX ROWID | KDD_BREAK | | INDEX UNIQUE SCAN | PK_KDD_BREAK | | TABLE ACCESS BY INDEX ROWID | KDD_BREAK_BINDING | | INDEX UNIQUE SCAN | PK_BREAK_BINDING | | INDEX RANGE SCAN | PK_KDD_BREAK_MTCHS | | VIEW | TRADE_EXCTN_DTLS_VW | | UNION-ALL PARTITION | | | TABLE ACCESS BY GLOBAL INDEX ROWID| TRADE | | INDEX UNIQUE SCAN | PK_TRADE | | TABLE ACCESS BY GLOBAL INDEX ROWID| EXECUTION | | INDEX UNIQUE SCAN | PK_EXECUTION | According to the plan the Trade table is being Scanned using an Index. But the Wait events show a DB file scattered read on the Trade Table which indicates a Full Table scan. These are also Paralel processes Trampling on Each Other i.e. i have Got p001 trying to read the same block as P002 and P001 waiting on Buffer Busy waits. Any help is greatly appreciated. Rgds, Ganesh -- //www.freelists.org/webpage/oracle-l