Re: [GENERAL] Partitions and indexes

2011-02-26 Thread Amitabh Kant
On Sun, Feb 27, 2011 at 12:30 AM, John R Pierce wrote: > On 02/26/11 10:42 AM, Amitabh Kant wrote: > >> On Sat, Feb 26, 2011 at 11:52 PM, John R Pierce > pie...@hogranch.com>> wrote: >> >>On 02/26/11 10:01 AM, Alban Hertroys wrote: >> >>On 26 Feb 2011, at 18:04, Amitabh Kant wrote: >>

Re: [GENERAL] Partitions and indexes

2011-02-26 Thread John R Pierce
On 02/26/11 10:42 AM, Amitabh Kant wrote: On Sat, Feb 26, 2011 at 11:52 PM, John R Pierce > wrote: On 02/26/11 10:01 AM, Alban Hertroys wrote: On 26 Feb 2011, at 18:04, Amitabh Kant wrote: Now if I partition the table T2 based on field T1id,

Re: [GENERAL] Partitions and indexes

2011-02-26 Thread Amitabh Kant
On Sat, Feb 26, 2011 at 11:52 PM, John R Pierce wrote: > On 02/26/11 10:01 AM, Alban Hertroys wrote: > >> On 26 Feb 2011, at 18:04, Amitabh Kant wrote: >> >> Now if I partition the table T2 based on field T1id, making sure that >>> each distinct T1id is provided its own child table >>> >>> Table

Re: [GENERAL] Partitions and indexes

2011-02-26 Thread John R Pierce
On 02/26/11 10:01 AM, Alban Hertroys wrote: On 26 Feb 2011, at 18:04, Amitabh Kant wrote: Now if I partition the table T2 based on field T1id, making sure that each distinct T1id is provided its own child table Table T2C1 (inherited from T2, T1id field only contains 1 for all rows) Table T2C2

Re: [GENERAL] Partitions and indexes

2011-02-26 Thread Alban Hertroys
On 26 Feb 2011, at 18:04, Amitabh Kant wrote: > Now if I partition the table T2 based on field T1id, making sure that each > distinct T1id is provided its own child table > > Table T2C1 (inherited from T2, T1id field only contains 1 for all rows) > Table T2C2 (inherited from T2, T1id field only

Re: [GENERAL] Partitions and indexes

2011-02-26 Thread Amitabh Kant
On Fri, Feb 25, 2011 at 1:17 PM, Chetan Suttraway < chetan.suttra...@enterprisedb.com> wrote: > > > On Wed, Feb 23, 2011 at 12:52 PM, Amitabh Kant wrote: > >> Hello >> >> If I have partitioned a table based on a foreign key in a manner where >> every child table will only have data for single valu

[GENERAL] Partitions and indexes

2011-02-22 Thread Amitabh Kant
Hello If I have partitioned a table based on a foreign key in a manner where every child table will only have data for single value of the foreign key, do I need to create a index for the foreign key in the primary and/or child tables? I am using version 8.4 With regards Amitabh