Table/Index Partition Schemes

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

 or

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