2 ms·
There's no technical reason why one couldn't just select or join from an index as if it was a table or a view is there? We also write queries knowing it will u
by magicalhippo 5y ago
There's no technical reason why one couldn't just select or join from an index as if it was a table or a view is there?
We also write queries knowing it will use a specific index, or we will create an index because of a specific query. And then we have to have a scheduled task to periodically recalculate statistics just so the DB server doesn't get silly ideas.
Of course it could be abused, but I'm in favor of having ways of letting programmers tell computers exactly what to do. Sometimes we really do know best.