Hrm... so it is going to need to rebuild all the indexes, not just the
table I am adding... doh... oh well, should still be faster, I'd guess.
Probably my best bet in this case is to create a new merged table with the
new table and all the other old ones, then replace the old merged table
with
"Anthony R. J. Ball" wrote:
> Ok, so to follow... Paul Dubois told me the little
> RENAME TABLE trick to swap out a table... Will that work
> on a table in a MERGE, or are there different hoops to
> jump through?
Your table names need to be unique. Then it should work just fine.
o If you do
Ok, so to follow... Paul Dubois told me the little
RENAME TABLE trick to swap out a table... Will that work
on a table in a MERGE, or are there different hoops to
jump through?
On Thu, Nov 15, 2001 at 02:01:44PM -0800, Bill Adams wrote:
> "Anthony R. J. Ball" wrote:
>
> > I was just readin
"Anthony R. J. Ball" wrote:
> I was just reading DOCS for MERGE tables... and they
> look like exactly what I want.
>
> I have a large lookup table that I use to track down
> where I want to find my data, which gets loaded into
> different tables at different times of the day
> (financial dat
