Modifications to the table definitions to add indices that should be used when searching the database. Added an upgrade script to create these indices as well. Modified QueryTerm.java to use the '=' comparator rather than 'LIKE' so that we can do index scans rather than table scans. This needs to be tested.
Modifications to the table definitions to add indices that should be used
when searching the database. Added an upgrade script to create these
indices as well. Modified QueryTerm.java to use the '=' comparator rather
than 'LIKE' so that we can do index scans rather than table scans. This needs
to be tested.