Table/Index Partition Schemes

From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Sat, 15 Dec 2007 01:58:49 GMT
Message-ID: <txG8j.78276$YL5.44270@newssvr29.news.prodigy.net>

Which would be the more appropriate way to define partitioned indexes on a partitioned table:

table_1

 table_1_partition_2000  data tablespace 1
 table_1_partition_2001  data tablespace 2
 table_1_partition_2002  data tablespace 3

index_1

 table_1_partition_2000  index tablespace 1
 table_1_partition_2001  index tablespace 2
 table_1_partition_2002  index tablespace 3

index_1

 index_1_partition_2000  index tablespace 1
 index_1_partition_2001  index tablespace 2
 index_1_partition_2002  index tablespace 3

Is one any better than the other or are they both about the same for performance and/or manageability? Received on Fri Dec 14 2007 - 19:58:49 CST