Try something like: SELECT /*+ INDEX(l item_order_ix) */ l.line_item_id, order_id, l.unit_price * l.quantity FROM order_items l WHERE l.order_id = :b1; to force using the corresponding index.
2009/4/28 Daiesh <mcavenkad...@gmail.com> > > Hi All, > > When i execute the query using joining with 3 tables , index are not > used and cost is too high. > > Please any one of you suggest how to reduce the cost or anyway to > execute that query fast. > > Advance thanks > > Thanks > venkadesh > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
