Order by Slowing down
I have a table with presorted data on cusynum. The queries with the
full table scan do not have any problems, the output comes as already sorted by custnum. The queries using the indexes don't produce the sorted output so ORDER BY CUSTNUM is added to sort the output, which makes the performance horrible. The CUSTNUM column is CHAr(17) and there is a non unique B*TREE index on it.
IS there a way to avoid the sorting ?.
I would appreciate any help on this issue.
Click Here to Expand Forum to Full Width