Help needed to make oracle retrival faster....

Quote:

---

Originally Posted by slimdave

Oh, you'd better be sure that you need that distinct as well

---

LIKE...LIKE...LIKE...LIKE...LIKE...perhaps they should scrap everything and start over. :rolleyes:

Step # Step Name
5 MERGE JOIN [CARTESIAN]
2 CS22USER.PO_HEADERS TABLE ACCESS [BY INDEX ROWID]
1 CS22USER.PK_PO_HEADERS INDEX [RANGE SCAN]
4 BUFFER [SORT]
3 CS22USER.ITEM_DCS TABLE ACCESS [FULL]
6 CS22USER.PK_PO_DETAILS INDEX [RANGE SCAN]

You can add a hint (NO_USE_MERGE) to disable merge join cartesian, if your oracle release 10g.

The hint, USE_NO_MERGE is not available in 9i, so you can try USE_HASH or USE_NL hint to avoid merge join.