PL/SQL (MOSC)

MOSC Banner

simple INDEX vs range scan

edited Jun 16, 2011 6:34AM in PL/SQL (MOSC) 7 commentsAnswered
 I am trying to get rid of range scan - but Oracle does (as trace shows) INDEX   MODE: ANALYZED (RANGE SCAN) OF
                      'AP_INVOICES_N4' (INDEX)  when scanning ap_invoices_all - I put INDEX hint as follows:

    SELECT /*+ INDEX(aia AP_INVOICES_N4) */

I have WHERE aia.invoice_amount = v_invoice_amount  ... as a filter

But  Oracle still scanning by range  'AP_INVOICES_N4'

What do I do...

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center