I have a question.... I have to query a 9 million row table with more than 40 columns... the query will check somany metrics in the WHERE condition like x>1 OR y>2.5 OR a>4 etc .... number of conditions are more than 20 .... this is taking forever when i run all together with a where clause and OR conidtions. ... what is the best way to do this ?
How long does your query take if the table is empty, or only has a few rows? If it still takes a long time, you might be seeing an optimizer performance bug.