[OPEN-ILS-GENERAL] SQL Query Performance

[Galen Charlton]

Hi,

On Fri, Apr 26, 2013 at 12:25 PM, Joshua D. Drake <jd at commandprompt.com> wrote:
> Granted if a unique index is required we can use a unique index as well. My
> only point was adding a secondary partial index was probably not the way to
> go and that adding a generic index on barcode would service the user better.

But nobody suggested adding a secondary partial index.  I made
reference to the Pg documentation concerning partial indexes simply to
point to a source of more information about the topic being discussed.

Pointing to additional reading material is a habit I find hard to
shake after having consorted with librarians for so long. ;)

Regards,

Galen
--
Galen Charlton
Manager of Implementation
Equinox Software, Inc. / The Open Source Experts
email:  gmc at esilibrary.com
direct: +1 770-709-5581
cell:   +1 404-984-4366
skype:  gmcharlt
web:    http://www.esilibrary.com/
Supporting Koha and Evergreen: http://koha-community.org &
http://evergreen-ils.org