MySQL Forums
Forum List  »  Optimizer & Parser

Re: Is the query order guaranteed using Btree indexes and no ORDER BY
Posted by: Peter Brawley
Date: May 29, 2019 03:00PM

Quote

From the literature the below query rows/results should be ordered by columns c1, c2, c10 where c10 may have 1 or more distinct values.

Eh? What literature is that?

A fundamental rule of relational databases (eg EF Codd's rule 8) is that query order is undefined unless specified.

If you want to specify order, add an Order By clause.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Is the query order guaranteed using Btree indexes and no ORDER BY
560
May 29, 2019 03:00PM


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.