Re: [OPEN-ILS-GENERAL] SQL Query Performance

[Martha Driscoll]

Thanks for the explanation everyone.  Now I understand the planner did 
not use the index at all because the deleted condition was not specified 
in the original query.

I'm always happy to learn more about the database and appreciate the 
link to the partial index documentation.

Martha Driscoll
Systems Manager
North of Boston Library Exchange
Danvers, Massachusetts
www.noblenet.org