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 8848286541a0875965154735f052f2d913f7e222) @@ -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