View Single Post
Old 2018-05-14, 18:42   #1517
chalsall
If I May
 
chalsall's Avatar
 
"Chris Halsall"
Sep 2002
Barbados

222378 Posts
Default

Quote:
Originally Posted by Mark Rose View Post
That would be the case if the schema were correctly designed. But I have a feeling that's not the case, as usage has evolved over the years.
Please forgive me for this, but as you know SQL handles AND and OR statements really quite well.

"SELECT COUNT(*) FROM exponent WHERE (state=1 OR state=5) GROUP BY exponent%1000000" works fine, for example. And uses cached indexes.

I would swear to make my point, but there's little demonstrated upside....

Last fiddled with by chalsall on 2018-05-14 at 18:50 Reason: YELLED THE SQL. It doesn't matter, but some like the clarity....
chalsall is offline   Reply With Quote