[OPEN-ILS-GENERAL] SQL Query Performance

[Galen Charlton]

Hi,

On Fri, Apr 26, 2013 at 12:11 PM, Joshua D. Drake <jd at commandprompt.com> wrote:
> Dropping the partial index and only relying on asset.copy(barcode):

Dropping the partial index also means dropping the constraint
enforcing the uniqueness of non-deleted item barcodes.  That's a
pretty important constraint as far as the business logic is concerned.

Of course, there is nothing preventing an Evergreen user from *also*
adding a full (non-unique) index on asset.copy (barcode); that could
certainly be useful if they expect to be doing a lot of ad hoc queries
on withdrawn items where the barcode is a relevant query filter.

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