1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Query running very slow

Discussion in 'Oracle Financials' started by aayan_110, Jan 18, 2011.

  1. aayan_110

    aayan_110 Active Member

    Likes Received:
    Trophy Points:
    Guyz need help

    In gl_je_lines table have records more tha 10 millions

    And in table one field effective date when i give this in
    where from >= effective date 01-JAN-2010 and effective date <= 31-DEC-2010
    condition its take abt 30 minutes to retrieve data

    I made index on effective date column but its only working on this condtion

    select * from gl_je_lines where effective_date = '01-JAN-2010

    on this condition data coming in seconds

    but its not working in a range condition from effective date to to effective date

    Can any one help me please...