In the last episode (Dec 18), Arnoldus Th.J. Koeleman said:
> I have a live feed datasource that inserts into 8 different tables( but
> they are all the same layout only differennt regions) and i am not
> allowed to change this since it is from a customer.
> As with Oracle you can create a materialized view that will combine
> those eight tables into one physical table and those will be refreshed
> on the fly or on certain times.
> Is this also possible in MySQL since we want to query on one table to
> find the record instead off eight.
As long as all the tables have the exact same column definitions, you
can use a MERGE table to provide a combined view of them all. I have
found that they only perform well under MySQL 4.1.1, though. Older
versions had a tendency to perform full table scans across the lower
tables instead of using indexes.
|• Combining tables||Arnoldus Th.J. Koeleman||18 Dec|
| • Re: Combining tables||Dan Nelson||18 Dec|