MySQL Forums
Forum List  »  Archive Storage Engine

Re: No Indexes??
Posted by: Brian Aker
Date: August 29, 2005 02:20PM

Archive was designed for cases where table scans are common. In MySQL indexes are used in cases where we would touch less then 30% of the data. The Archive engined was designed assuming that the queries always will touch more then 30% of the data.

Options: ReplyQuote


Subject
Views
Written By
Posted
9918
August 29, 2005 04:28AM
6281
August 29, 2005 06:03AM
5822
August 29, 2005 12:37PM
5663
August 29, 2005 01:30PM
Re: No Indexes??
5648
August 29, 2005 02:20PM
5379
September 06, 2005 03:49PM
5603
November 07, 2005 07:42PM
5654
November 30, 2005 05:45PM
5475
February 14, 2007 11:23PM
5503
February 15, 2007 10:10AM
5375
February 15, 2007 12:06PM
5770
February 18, 2007 03:50AM
5511
February 19, 2007 05:55AM
5388
February 22, 2007 04:37PM


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.