Kbase P114509: Does using ORDER BY with DESC in SQL-92 cause a temp-table to be created?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/22/2006 |
|
Status: Unverified
GOAL:
Does using ORDER BY with DESC in SQL-92 cause a temp-table to be created?
FACT(s) (Environment):
OpenEdge 10.x
Progress 9.x
FIX:
At the present time the use of ORDER BY with the DESC option causes the SQL-92 query optimizer to generate a temp-table on the server side to sort the data before it is returned.