New answers tagged

4

The answer is kind of "no" but more "your question does not have an answer because it's based upon incorrect assumptions". 1) Tables are not really stored in a particular order. 2) Even if they were, how would the DB know that the question had been answered until it had finished reading the entire table. Putting things "up front" would not help. 3) What ...


0

The ORDER BY, particularly in the absence of an index on column D, will require a sort operation. If there is not enough memory allocated in the sort heap for the statement, it will cause an overflow of data being sorted into a temporary table. The table width will be the sum of the column widths of the result set being sorted, plus some overhead. There ...



Top 50 recent answers are included