Re: Can MySQL go backwards through index?
Posted by:
Tom Byars
Date: March 09, 2015 03:59AM
I suppose those queries should include an order by clause
select * from LargeTbl where Col1 = Col1Val and Col2 < Col2Val
order by Col2 desc limit 10;
and
select * from LargeTbl where Col1 = Col1Val and Col2 > Col2Val
order by Col2 limit 10;
Subject
Written By
Posted
Re: Can MySQL go backwards through index?
March 09, 2015 03:59AM
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.