Re: [HACKERS] relational class vs partitioned table (was

2005-10-11 Thread Simon Riggs
On Mon, 2005-10-10 at 19:58 -0700, Trent Shipley wrote: > Of course, there is no reason a relation in a relational class might not be > huge. Well, as a designer, I would make it so. > Orthoganal partion rules would be created for the class. The rules would be > applied to each member relati

[HACKERS] relational class vs partitioned table (was Inherited indexes)

2005-10-10 Thread Trent Shipley
On Tuesday 2005-10-04 13:54, Simon Riggs wrote: > On Tue, 2005-10-04 at 18:16 +0200, Zeugswetter Andreas DAZ SD wrote: > > > Another possibility is optimizing for the special case of > > > indexing on a partitioning key. In this case, index values > > > would be very localized to one table, so just