Re: select count() out of memory

> tfinneid@student.matnat.uio.no wrote:
>> Thats good enough for me, thats exactly what I want.
>
> In that case, why use partitions at all?  They are simple independent
> tables.

For two reasons,
- the data logically belongs together.
- because its more practical to create tables as childs of a parent table
than as independent tables.
   - changes to the table is applied to all partitions, and prohibits
tables with different dd.
   - performing the create operation does not require the source code to
contain the ddl of the parent table.


regards

thomas