Re: UPDATE in Kombination mit ORDER BY sehr langsam
Hallo Tobias,
kannst Du mir trotzdem den EXPLAIN nochmal zeigen?
Die beiden KEY-Vorschläge können (nach dem EXPLAIN) wieder "gedroppt" werden. Wenn die Datenmenge weiter ansteigt könnte es sein, dass einer der beiden Index wieder wichtig wird.
Grüße
Thomas
Subject
Views
Written By
Posted
2052
July 30, 2012 04:30AM
1026
August 01, 2012 03:06AM
1152
August 06, 2012 10:40AM
1024
August 08, 2012 06:09AM
1057
August 08, 2012 09:26AM
1194
August 08, 2012 09:50AM
1219
August 09, 2012 02:22AM
902
August 09, 2012 02:20AM
1244
August 09, 2012 02:45AM
1066
August 09, 2012 03:20AM
Re: UPDATE in Kombination mit ORDER BY sehr langsam
1061
August 09, 2012 03:31AM
991
August 09, 2012 03:47AM
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.