Re: Eliminate filesort in update query
Posted by:
Rick James
Date: October 03, 2014 10:09PM
What do you get from
EXPLAIN UPDATE queue
FORCE INDEX(queue_index) -- I added this
SET acquired = "test"
WHERE acquired IS NULL AND queue_name = "q1"
ORDER BY priority, id LIMIT 1;
(or is it even valid syntax?)
And, did you submit a bug report? If so, plz post the link.
Subject
Views
Written By
Posted
2496
September 23, 2014 02:48AM
1007
September 23, 2014 09:59PM
941
September 24, 2014 01:25AM
986
September 24, 2014 08:40PM
988
September 25, 2014 05:48AM
921
September 26, 2014 04:39PM
972
October 01, 2014 06:49AM
Re: Eliminate filesort in update query
985
October 03, 2014 10:09PM
1020
October 04, 2014 03:13AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.