[OPEN-ILS-GENERAL] SQL Query Performance

Martha Driscoll driscoll at noblenet.org
Fri Apr 26 16:33:44 EDT 2013


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



More information about the Open-ils-general mailing list