SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PO_HEADERS_ALL Taking Long time to query up.

594709Apr 21 2008 — edited Apr 21 2008

Hi all,
i have a query where in iam using PO_HEADES_ALL table and when i run explain plan on that query it shows me that PO_HEADERS_ALL is costing a lot, please check below for the explain plan 10th point.

Plan
9 For each row retrieved by step 6, the operation in step 8 was performed to find a matching row.
10 Every row in the table PO.PO_HEADERS_ALL is read.

The only parameter i gave on PO_HEADERS_ALL table is org.

Can any one of you tell me how to move forword to run the query fast.

Thank you.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 19 2008

Added on Apr 21 2008

2 comments

471 views