In the absence of an Order By clause in a SOQL query, what order will Salesforce return results in?
Clearly if ordering is important then Order By should be specified, but I recently encountered a question about what the order would be if it was undefined.
My initial thoughts were Salesforce would return them in whatever order suited them. Much like SQL. For simple queries this would typically line up with the creation date descending and the Id ascending. For more complex queries it would depend on the joins being performed.