I suspect "slightly" really means infinitesimally faster as the real time is in scanning the table and checking for visibility
But the rest of the query usually drowns that out; e.g. in my tests that represented a difference of 2 seconds for a query taking 47 seconds
-
-
For example, consider the performance difference between "select count(1) from ...", "select count(1), count(2) from ...", and "select count(1), count(*) from ..." on the same input. (Note that the two count() calls MUST be different or they will be combined)
-
2/47 seconds is still 5%, though. Does the parser have some pre-existing way of recognising constant expressions like "1"? Might be a low hanging fruit... It probably isn't, as these things are often more complicated than it seems from the outside.
- 4 more replies
New conversation -
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.

