3 ms·
In my old tests, with data clustered by organization_id, the SQLite and SQLServer run the query very fast. > is not to be so certain that there is "a correct q
by zac23or 3y ago
In my old tests, with data clustered by organization_id, the SQLite and SQLServer run the query very fast.
> is not to be so certain that there is "a correct query plan"
Yes, data distribution, type, row size, machine power, SSD vs HD can affect which is the “best plan”.