13 Replies Latest reply: Dec 27, 2012 8:50 AM by imran khan RSS

    How to increase performance of the select query

    SShubhangi
      Following query is taking 15 Minutes to excute

      select *
      from CUSTOMER
      where (ID in (1,2) and status > 3)
      and ((((NOT (TYP_PORTFOLIO = 8 or TYP_PORTFOLIO = 9))) and TYP_BALANCE = 2));

      It returns 450,000 records in 15 minutes.

      How can i reduce this excution time ?

      I have added BITMAP INDEX for ( ID,status,PORTFOLIO,TYP_BALANCE)

      Please help / reply