Forum Stats

  • 3,770,153 Users
  • 2,253,079 Discussions
  • 7,875,349 Comments

Discussions

Data distribution on a local non prefixed index

Daniel Haviv
Daniel Haviv Member Posts: 9
edited Jun 20, 2013 6:06AM in General Database Discussions

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

Tagged:

Answers

This discussion has been closed.