calendarw wrote:
> Hi,
>
> I need to combine 10 tables which contain same table structure and join an
> "other table" to show the latest 200 record, I am join the "other table"
> first and using union statement to select all record now but the collection
> time is super slow, how can I improve the collection speed?
Start by providing the information needed to diagnose the problem.
Post the output of EXPLAIN ANALYSE <query> along with the query SQL and
any table definitions/sizes you think are useful.
-- Richard Huxton Archonet Ltd