Re: Can MySQL go backwards through index?
Posted by:
Rick James
Date: March 10, 2015 11:25PM
Yes, MySQL can walk through a 'range' in reverse order. To 'see' this, do
FLUSH STATUS;
SELECT ... ORDER BY xx DESC;
SHOW SESSION STATUS LIKE 'Handler%';
You will see several counters, including one called Handler_read_prev.
Subject
Written By
Posted
Re: Can MySQL go backwards through index?
March 10, 2015 11:25PM
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.