Hello,
I've split my data in daily tables to keep them in an acceptable size.
Now I have quite complex queries which may be very long if I need to query a
large number of daily tables.
I've just made a first test wich resulted in a query being 15KB big annd
containing 63 UNION.
The Query
* Marc Mamin ([EMAIL PROTECTED]) wrote:
I've just made a first test wich resulted in a query being 15KB big annd
containing 63 UNION.
If the data is distinct from each other or you don't mind duplicate
records you might try using 'union all' instead of 'union'. Just a
thought.
Stephen