On 10/7/2014 4:44 PM, Jonathan Vanasco wrote:
I had created a "unique index" on a mix of two columns to enforce a constraint
: (resource_type_id, lower(archive_pathname))
i've noticed that searches never use this. no matter what I query, even if
it's only the columns in the index. I'm seeing
I have a table with over 1MM records and 15 columns.
I had created a "unique index" on a mix of two columns to enforce a constraint
: (resource_type_id, lower(archive_pathname))
i've noticed that searches never use this. no matter what I query, even if
it's only the columns in the index. I'm