Index: lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20130812.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20130812.sql,v
diff -u -r1.2 -r1.3
--- lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20130812.sql	27 Aug 2013 10:22:39 -0000	1.2
+++ lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20130812.sql	30 Sep 2013 20:46:17 -0000	1.3
@@ -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;