great. thx!
On 4/17/07, Daniel Kasak <[EMAIL PROTECTED]> wrote:
Arun Kumar PG 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 1 OR conditions on the
> field e.g.
> where X=10 OR x=12 OR x=13 OR x=15.
Arun Kumar PG 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 1 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?
Yes the inde
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:
