http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9681 Bug ID: 9681 Summary: Add some indexes in database Classification: Unclassified Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Database Assignee: gmcharlt@gmail.com Reporter: fridolyn.somers@biblibre.com Some table columns should have an index to speed SQL queries : - statistics table has only one index (used to make heavy queries for reports) - itemtype should have an index in items and biblioitems (this is used in circulation to check the number of existing issues of a specific item type) - issue.branchcode and issue.issuingbranch Note that the fact that an index is automatically created for foreign keys in InnoBD seems to be in discussion, so better create it explicitly. -- You are receiving this mail because: You are watching all bug changes.