Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Later
-
None
-
None
-
None
-
None
Description
Sorry for the vague title.
As mentioned PHOENIX-1281, I have seen some runtime anomalies for queries that should take similar amounts of time.
40m row tables, 4 integer column + integer key. All columns (except keys set to 1)
| select distinct(v1) from x where v1 = 1 | 21s |
| select distinct(v1) from x where v1 <> 1 | 50s |
| select count(*) from x where v1 <> 1 | 45s |
| select count(*) from x where v1 = 1 | 9.5s |
Interestingly the queries that filter all rows are 5x slower.