I have the following index

create unique index open_issues_unique on issue (status, type, reference_id) where status = 'OPEN';

This means the value of the column status will always be OPEN. Does this have a negative impact on the index performance? Can I simply remove status from the index as I have the where clause?

  • You may either remove this column from the index expression or move it to the end if the expression (this can be useful when the index is covering one for a query).
    – Akina
    Feb 22 at 11:16


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.