Peter Geoghegan on Twitter: "@BrentO @TanelPoder The optimizer more or less assumes statistical independence across columns ("attribute value independence assumption"). If your schema flies in the face of that assumption (e.g. EAV design) then you'll probably always get bad query plans, no matter what." / Twitter

If you could give just one piece of advice about writing good queries, what would it be?

146

Replying to

and

The optimizer more or less assumes statistical independence across columns ("attribute value independence assumption"). If your schema flies in the face of that assumption (e.g. EAV design) then you'll probably always get bad query plans, no matter what.

9:15 PM · May 3, 2021Twitter Web App

Replying to

and

Very true.

Conversation