MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: Delete slow... randomly
Posted by: Rick James
Date: June 05, 2014 08:01PM

> I just have INDEX(tetUID, cudUID) but not INDEX(cudUID,tetUID): I will update my table!

Either INDEX will work equally well for your DELETE. There is no advantage to having both, at least not for that DELETE.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Delete slow... randomly
2798
Francesco De Carlo
June 02, 2014 09:15AM
Re: Delete slow... randomly
1085
Rick James
June 03, 2014 09:51AM
Re: Delete slow... randomly
1051
Francesco De Carlo
June 04, 2014 03:43AM
Re: Delete slow... randomly
909
Rick James
June 05, 2014 08:01PM


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.