Is it faster to do a query such as
WHERE columnid > 0or
WHERE columid=1 OR columid=2
1 result in 0.0038 seconds.
-
Is it faster to query by doing greater than or doing multiple equals?
We have a large table with lots or rows. One of the columns has the values either 0,1,2.
Is it faster to do a query such as
or