Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040031.sql =================================================================== diff -u --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040031.sql (revision 0) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040031.sql (revision 62547dea4495d2f7bb30c1d0a99d01bdc3edabe5) @@ -0,0 +1,10 @@ +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS = 0; + +-- LDEV-3292 Add index on Activity table + +CREATE INDEX lams_learning_activity_tool_content_id ON lams_learning_activity(tool_content_id); + +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS = 1; \ No newline at end of file