Re: No Indexes??
Ran some tests - here's my observations:-
o Can an ARCHIVE table be used in a MERGE table union?
I think the answer would have to be yes - but only if all tables in the union (including the merge definition) had no indexes ... because the ARCHIVE engine doesn't support indexes.
o Auto-increment fields are not supported. I ran an "alter table type-archive" on a MYISAM table and got an error that you cannot have auto_increment in the table.
o No indexes - a problem?
Maybe not. If indexes are used for speed on a MYIASM table, then they appear not to be needed in the ARCHIVE format because the small footprint of the table (75% less space in my tests) makes up for the need to read the entire table. Still... !
o No indexes - a problem (part 2) ?
Maybe yes - if you use indexes as a primary key. Can't have any indexes - which means you can't have a primary key either. "INSERTS" are allowed - so it's not like an ARCHIVE table is meant for read-only purposes.
The plot thickens ;)
Dean
Subject
Views
Written By
Posted
10216
August 29, 2005 04:28AM
Re: No Indexes??
6396
August 29, 2005 06:03AM
5959
August 29, 2005 12:37PM
5778
August 29, 2005 01:30PM
5770
August 29, 2005 02:20PM
5489
September 06, 2005 03:49PM
5719
November 07, 2005 07:42PM
6170
November 30, 2005 05:45PM
5595
February 14, 2007 11:23PM
5653
February 15, 2007 10:10AM
5518
February 15, 2007 12:06PM
5893
February 18, 2007 03:50AM
5640
February 19, 2007 05:55AM
5495
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.