Re: No Indexes??
>> o Can an ARCHIVE table be used in a MERGE table union?
>No, but in 5.1 there is a partition engine which will give you more then MERGE.
Oooh fabulous! I'll look forward to reviewing/implementing that. MERGE has been very, very useful in our setup allowing me to manipulate tables & database (to a certain extent) without having to recode our applications.
>> The engine was really designed for being able to do fast scans
Yes, my tests showed that SELECTS on an ARCHIVE table ran reasonably quickly on millions of records, even though there were no indexes to help optimize the query.
Ta much Brian for the reply.
Subject
Views
Written By
Posted
9933
August 29, 2005 04:28AM
6283
August 29, 2005 06:03AM
5839
August 29, 2005 12:37PM
Re: No Indexes??
5665
August 29, 2005 01:30PM
5655
August 29, 2005 02:20PM
5384
September 06, 2005 03:49PM
5607
November 07, 2005 07:42PM
5677
November 30, 2005 05:45PM
5477
February 14, 2007 11:23PM
5505
February 15, 2007 10:10AM
5377
February 15, 2007 12:06PM
5772
February 18, 2007 03:50AM
5513
February 19, 2007 05:55AM
5391
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.