3 ms·
> the fully optimized query will run the same way pretty much everywhere This is not correct. The query will still be run through an optimizer, and the optimiz
by falcolas 13y ago
> the fully optimized query will run the same way pretty much everywhere
This is not correct. The query will still be run through an optimizer, and the optimizer will still pick its own path of execution based on indexes and data uniqueness (as identified from the table metadata or its own dives into the data).
There are ways to force an optimizer to take a certain path, but those are dependent on which DB you're using.
Unfortunately, the original dataset doesn't exist online, so we can't verify their claims that it really is database agnostic.
- buckbova 13y agoAnd then there are table statistics or fragmented indexes that cause the optimizer to choose a different path. Even when you've done everything and you think the optimizer should choose a particular index it will surprise you.