Re: LOCAL INDEXES

Steve,

Not true. If you have a partitioned table with 3 partitions (t1, t2, t3), then let's examine a sample of your indexing options:

1. local indexing creates 3 index partitions (l1 for t1, l2 for t2, l3 for t3)
2. gloabl indexing could have 2 partitions (g1 for t1 and t2, g2 for t3)
3. plain old index can only be 1 segment (i1 for t1 - t3)

There is no way this is internally the same. While I could create a gloabl index for with one partition for all three partitions -- it is only logically an equivalent ... Received on Wed Jun 24 1998 - 10:18:32 CDT