Projection of a WHERE attribute (no replies)
(MySQL.com) Hi,
I have a table storing time series values (Id, Date, Value, Quality).
When I want to select the last Value for a given Id, I see weird optimizer choices depending on the query :
"SELECT max(Date) FROM Values WHERE Id = 1" (0.00sec) is a lot