Three factors affecting sort speed are
The number of rows selected
The number of columns in the ORDER clause
The defined length of the columns (not the actual length in case of VCHAR)
If the physical length of the record is long, DBMS may perform a tag sort in dynamic memory with only the necessary part of record.
Position of row when sorting column with NULL various from DBMS to DBMS.
No comments:
Post a Comment