Index: lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20130812.sql
===================================================================
diff -u -r0e43338eb6858603fd3b41c384cee7828d48f0e9 -rdbfb4c0b2e50a8bd187752e1ee74cb62fd571093
--- lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20130812.sql	(.../patch20130812.sql)	(revision 0e43338eb6858603fd3b41c384cee7828d48f0e9)
+++ lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20130812.sql	(.../patch20130812.sql)	(revision dbfb4c0b2e50a8bd187752e1ee74cb62fd571093)
@@ -4,20 +4,18 @@
 ----------------------Put all sql statements below here-------------------------
 
 --LDEV-3085 Autosave feature for MCQ
-DELETE FROM tl_lamc11_usr_attempt WHERE uid NOT IN ( 
-  SELECT uid
-  FROM (
-	SELECT attempt.uid
+CREATE TABLE temp_select AS SELECT attempt.uid
 	FROM tl_lamc11_usr_attempt attempt
 	INNER JOIN(
 	    SELECT que_usr_id, mc_que_content_id, max(attemptOrder) attemptOrder
 	    FROM tl_lamc11_usr_attempt
 	    GROUP BY que_usr_id, mc_que_content_id
-	) ss ON attempt.que_usr_id = ss.que_usr_id AND attempt.mc_que_content_id = ss.mc_que_content_id AND attempt.attemptOrder = ss.attemptOrder
-  ) foo
-);
-ALTER TABLE tl_lamc11_usr_attempt DROP COLUMN attemptOrder;
+	) ss ON attempt.que_usr_id = ss.que_usr_id AND attempt.mc_que_content_id = ss.mc_que_content_id AND attempt.attemptOrder = ss.attemptOrder;
+ALTER TABLE temp_select ADD INDEX index1 (uid ASC);
+DELETE FROM tl_lamc11_usr_attempt WHERE uid NOT IN (SELECT uid FROM temp_select);
+DROP TABLE temp_select;
 
+ALTER TABLE tl_lamc11_usr_attempt DROP COLUMN attemptOrder;
 ALTER TABLE tl_lamc11_que_usr DROP COLUMN last_attempt_order;
 ALTER TABLE tl_lamc11_que_usr ADD COLUMN number_attempts INTEGER DEFAULT 0;