MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: Delete statement taking more time for deleting 1 million records
Posted by: Rick James
Date: October 26, 2014 10:45AM

> Use the "between and" condition in where clause instead of a < or > . ( B+tree works well in a range condition).

The optimizer is smart enough to do < and > with a "range" scan.

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


Subject
Views
Written By
Posted
Delete statement taking more time for deleting 1 million records
4303
Raja Palanichamy
October 17, 2014 08:50AM
Re: Delete statement taking more time for deleting 1 million records
1915
Rick James
October 18, 2014 12:20PM
Re: Delete statement taking more time for deleting 1 million records
1493
Chrisa Torain
October 25, 2014 01:10AM
Re: Delete statement taking more time for deleting 1 million records
1325
Rick James
October 26, 2014 10:45AM


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.