Hi All,
Is it possible to create a partitioned index on a table which is not partitioned? If so what is such a partition called and please explain?
I have done some research on partitions and index partitions and this is where I hit the wall the 2nd time. As per my study there are 3 types of indexed partitions: Global index (which is on an entire partitioned table) then there is Local Index (on just the partition of the table) and then there is a non-partitioned index (over a non partitioned table).
Finally there is a subdivision of the Global index which is a Global Partitioned Index (A global index with a different index key then that of the table). But I also couldn't understand what a Global Non-Partitioned Index does on an indexed table? Does it mean, its a Global Index which is not partitioned on a partitioned table ?
Regards,
Aj
Is it possible to create a partitioned index on a table which is not partitioned? If so what is such a partition called and please explain?
I have done some research on partitions and index partitions and this is where I hit the wall the 2nd time. As per my study there are 3 types of indexed partitions: Global index (which is on an entire partitioned table) then there is Local Index (on just the partition of the table) and then there is a non-partitioned index (over a non partitioned table).
Finally there is a subdivision of the Global index which is a Global Partitioned Index (A global index with a different index key then that of the table). But I also couldn't understand what a Global Non-Partitioned Index does on an indexed table? Does it mean, its a Global Index which is not partitioned on a partitioned table ?
Regards,
Aj
Comment