Hi Arun, Instead of doing x=10 or x=10, use the IN condition where X in (10,20,30..etc), it would work better. But i guess there is a limit on the number of values specified in IN clause, I am not sure, need to check on that.
regards anandkl On 4/17/07, Arun Kumar PG <[EMAIL PROTECTED]> wrote:
Guys, I know this is a stupid thing but I wanted to know if we have an index on a column "X" and if i have a query having 10000 OR conditions on the field e.g. where X=10 OR x=12 OR x=13 OR x=15...... so on then will it give any benefits in terms of speed? thx - A
