sql - Ensuring result order when joining, without using an order_by -
I have a mysql plugin that will return the results set in a specified order. Part of the result set includes a foreign key, and I want to join that key, while ensuring that the order remains the same.
If I do something like this:
SID = F.Id's internal join of the sphends F. F. F, choose Fitil, where query = 'test; Filter = type, 2; Sort = atriosak: static ';
It seems that I am getting my results back so that Sphinx gives them returns. Is this a quote from mysql, or has I been assured that no involved order will change?
If you need a guaranteed command in the result of a query, use ORDER BY Do some more willpower thinking.
To give some information on this, several database execution steps are split in a way that can vary depending on the execution of the query, the available CPU volume, and optimization Just like the database can be estimated. If a query runs in parallel on many threads, the results may vary. If the plan changes, the results may vary if multiple queries are running simultaneously, the results may vary, if some data is cached in memory, the results may vary.
If you need to guarantee an order, use ORDER BY.
Comments
Post a Comment