4 ms·
There is no need for adding the boolean value to the index in this case, since it is constant (true). You can add a more useful column instead, like id or whate
by giovannibonetti 3y ago
There is no need for adding the boolean value to the index in this case, since it is constant (true). You can add a more useful column instead, like id or whatever your queries use:
CREATE INDEX ON session(id) WHERE is_active;