search

Flowminder / FlowKit

FlowKit: Flowminder CDR analytics toolkit
https://flowminder.github.io/FlowKit/
Mozilla Public License 2.0
86 stars 20 forks source link

Join queries never get an index #6602

Open greenape opened 2 months ago

greenape commented 2 months ago

For a Join query, no index will ever be created even if a subscriber column, or location column(s) are present.

greenape commented 2 months ago

Options here are to be a bit greedy on index creation (create an index if there's anything which resembles these columns, even with a suffix), allow specifying indexes to be created (in which case do we want to allow a bit more flex here and allow specifying the type of index?), do some juju and create the indexes that would have been created on the joinee queries.