[OPEN-ILS-GENERAL] SQL Query Performance

[Galen Charlton]

Hi,

On Fri, Apr 26, 2013 at 11:17 AM, Galen Charlton <gmc at esilibrary.com> wrote:
> Hi,
> The quick answer is that the asset.copy index on the barcode column
> also includes a clause to limit the index to copies that aren't
> deleted:

This part of the PostgreSQL documentation is worth a read to learn
more about partial indexes:

http://www.postgresql.org/docs/9.1/static/indexes-partial.html

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