How to get rid of "SORT ORDER BY"
Hi,
I have a question regarding query optimization. I have an Oracle database server 11.0.7.0 running on AIX 6.1.
I am executing the following statement:
SELECT /*+FIRST_ROWS(914) INDEX(AENDERUNG11 PK_AENDERUNG11_CAT)*/
aenderung11.ROWID, aenderung11.satznr, aenderung11.vsnr,
aenderung11.pkz, aenderung11.llfdnr, aenderung11.aktnr,
aenderung11.seslfdnr, aenderung11.eingbs, aenderung11.erlam,
aenderung11.aendart
FROM aenderung11
WHERE (aenderung11.pkey > :0)
ORDER BY aenderung11.pkey ASC
"pkey" is a virtual column containing a concatenation of the string values of all primary key columns.
"PK_AENDERUNG11_CAT" is an ascending index for "pkey".
This is the explain plan of the statement:
SELECT STATEMENT HINT: FIRST_ROWS Cost: 176,239
I have a question regarding query optimization. I have an Oracle database server 11.0.7.0 running on AIX 6.1.
I am executing the following statement:
SELECT /*+FIRST_ROWS(914) INDEX(AENDERUNG11 PK_AENDERUNG11_CAT)*/
aenderung11.ROWID, aenderung11.satznr, aenderung11.vsnr,
aenderung11.pkz, aenderung11.llfdnr, aenderung11.aktnr,
aenderung11.seslfdnr, aenderung11.eingbs, aenderung11.erlam,
aenderung11.aendart
FROM aenderung11
WHERE (aenderung11.pkey > :0)
ORDER BY aenderung11.pkey ASC
"pkey" is a virtual column containing a concatenation of the string values of all primary key columns.
"PK_AENDERUNG11_CAT" is an ascending index for "pkey".
This is the explain plan of the statement:
SELECT STATEMENT HINT: FIRST_ROWS Cost: 176,239
0