3 ms·
And then comes Oracle and insists on applying equality filters first, because, duh, they are fast, and never take any of those other details into consideration.
by marcosdumay 7y ago
And then comes Oracle and insists on applying equality filters first, because, duh, they are fast, and never take any of those other details into consideration.
Honestly, Postgres does it right - you can enforce your query plan to any level of detail you want.
- paulryanrogers 7y agoDoes PostgreSQL have plan hints now? I thought they were opposed to them for fear they become unmaintainable and hard to read.
- lfittl 7y agoIf you really want to, the pg_hint_plan extension can be used for this - though I would use it very sparingly, if at all: https://pghintplan.osdn.jp/pg_hint_plan.html https://pghintplan.osdn.jp/pg_hint_plan.html (available on some cloud providers as well)
- yen223 7y agoHow do you do that? Postgres doesn't even offer a way to enforce that specific indexes get used during a query as far as I know.