EXPLAIN PLAN for select * from test11 order by id desc;
SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY);
PLAN_TABLE_OUTPUT
"------------------------------------------------------------------------------------------"
"| Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time |"
"------------------------------------------------------------------------------------------"
"| 0 | SELECT STATEMENT | | 1076 | 1491K| | 3779 (1)| 00:00:01 |"
"| 1 | SORT ORDER BY | | 1076 | 1491K| 2160K| 3779 (1)| 00:00:01 |"
"| 2 | TABLE ACCESS FULL| test11 | 1076 | 1491K| | 3457 (1)| 00:00:01 |"
"------------------------------------------------------------------------------------------"