read with index and order very slow
Posted by:
K-H Heepe
Date: July 28, 2005 08:12AM
Hallo,
i have the following index and will read sequential and ordered by the key.
Without order command the rows not ordered
With order command it is very slow > 120 sec. What can I do?
phkdnr INDEX 78117 (phkdnr , pkdnr , provartnr )
SELECT *
FROM `provisionen`
WHERE `phkdnr` >= ''
AND `pkdnr` >= ''
AND `provartnr` >= '123456789'
order by 'phkdnr', 'pkdnr', 'provartnr'
limit 25, 50
Zeige Datensätze 0 - 49 (50 insgesamt, die Abfrage dauerte 126.3692 sek)
SQL-Befehl: SELECT * FROM `provisionen` WHERE `phkdnr` >= ''AND `pkdnr` >= ''AND `provartnr` >= '123456789'ORDER BY 'phkdnr', 'pkdnr', 'provartnr'LIMIT 25 , 50
Subject
Views
Written By
Posted
read with index and order very slow
2328
July 28, 2005 08:12AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.