Some times the issue is the way the indexes are managed. 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; or SELECT /*+NO_EXPAND */ p.header_id, l.line_id, l.revenue_amount FROM so_lines_all p, so_lines_all l WHERE p.header_id = :b1 AND (l.parent_line_id = p.line_id OR l.service_parent_line_id = p.line_id);
No_expand game me very good performance improvement. 2009/4/21 ddf <orat...@msn.com> > > > > On Apr 21, 7:09 am, Daiesh <mcavenkad...@gmail.com> wrote: > > Hi All, > > > > How do speed up the index range scan in Oracle? > > > > Advance wishes!!!.. > > > > Thanks > > Daiesh > > Why do you 'need' to 'speed up the index range scan'? Why do you > think that is the bottleneck? I'd be using autotrace instead of > simply using explain plan to see what I/O activity your generating > with that query. The index range scan is probably running as fast as > possible but it's generating a large result set to filter on another > criteria. Filtering large volumes of data will consume time, time you > might be able to save with a concatenated index. > > > David Fitzjarrell > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---