You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Queries of the form field = $0 when run on a Timestamp column (or Bool column) do not improve in performance when an index is added. We'd expect the speedup to be approximately equal to that of an integer column.
TimestampNode and BoolNode should have special handling if an index is available.
We should support Indexing all other column types (aside from links or collections).
The text was updated successfully, but these errors were encountered:
sync-by-unitobot
changed the title
Optimize Timestamp queries to use the index if available
Index Query Improvements
Nov 3, 2022
Timestamp and Bool queries make use of an index if available since #6376 so I'm going to close this. If we want to add index support for other column types I think we should track that separately as a new project.
Queries of the form
field = $0
when run on a Timestamp column (or Bool column) do not improve in performance when an index is added. We'd expect the speedup to be approximately equal to that of an integer column.The text was updated successfully, but these errors were encountered: