3To execute a query, the database server constructs a query 3plan and retrieves all qualifying rows that match the WHERE clause conditions. 3(Here a row refers to one set of values, as specified 3in the select list, from a single record in the table or joined tables that 3the FROM clause specifies.) If the query has no ORDER BY clause, the qualifying 3rows are sequenced in the order of their retrieval, which might vary with 3each execution; otherwise, their sequence follows the ORDER BY specification, 3as described in ORDER BY Clause.
3Whether or not the query specifies ORDER BY can affect which 3qualifying rows are in the result set if the Projection clause includes any 3of the following options:
3