retrieval request

For an unordered retrieval request, different executions of request may return the retrieved rows in a different sequence. I think this statement is true because the order of request is the key in row access in  database. Am i right? tks.
BeginToLearnAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
prerakshethConnect With a Mentor Commented:
True only conditionally. The sequence of rows fetched from the database are dependent on many things, including the natural order of storage, any joins made, and the plan used for execution.

So IF the data has not changed in any way (no insert, no delete, no updates), and IF the joins have not changed (same query executed again), then the row sequence WILL remain the same. In all other conditions, it is not guranteed.
0
 
BeginToLearnAuthor Commented:
tks
0
All Courses

From novice to tech pro — start learning today.