Data distribution on a local non prefixed index

Daniel Haviv

Hi,

I feel i'm a little confused on the subject of how data is distributed on a local non prefixed index.

Let's say I have a table calles SALES and it holds data for the last year partitioned by a date column called month (So that's 12 partitions, one for each month).

Now i'm creating the following index:

CREATE INDEX TESTIDX ON SALES(salesman_id) local;

What will happen is that I'll have 12 partitions on the index but to which partitions in the table are they referencing ?

Thanks,

Daniel

Daniel Haviv

Ok found a good explanation.

Each index partition will point only to the data in the corresponding table partition but the salesman_id might appear in other partitions as well so all index partitions would have to be scanned.

A good explanation can be found here (though not an Oracle DB but the concept is the same): http://support.altibase.com/manual/en/551b/html/Admin/ch07s02.html

Daniel