This discussion is archived
13 Replies Latest reply: Dec 27, 2012 6:50 AM by imran khan RSS

How to increase performance of the select query

SShubhangi Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points