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 index
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.. so
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?
thx
- A
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: