> > This could be a solution... but then I'm not sure how well would do
> > queries which need the first 10 records based on some criteria which
> > does not include the group id. I guess limit queries across the
union
> > of the partitions don't work too well for now, and we do
> have such queries.
You would query the parent (no union). Do you need order by's ?
Without order by it is currently no problem.
Do we push the limit down to the separate tables when we have an
appropriate
index for the order by (that could be a TODO item)?
(You need a max of "limit" rows per child in the outer order)
Or we would need to implement an efficient index merge node
for order by queries on parent (and union all's) with low limits
and an appropriate index.
Selecting the oldest x rows from a time partitioned table is a frequent
problem
we need to work around here too (Informix db).
Andreas