Re: DELETE query slow on Memory storage engine
You have an index on the timestamp column?
Memory engine uses Hash index by default, so that won't help your range search. You can recreate the index using btree on version 4.1 or above.
Subject
Views
Written By
Posted
19859
July 16, 2007 01:27PM
Re: DELETE query slow on Memory storage engine
9214
July 16, 2007 05:53PM
8914
July 25, 2007 09:00PM
6969
January 28, 2009 07:41AM
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.