468,268 Members | 1,695 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,268 developers. It's quick & easy.

Partitioned Index on a non partitioned table ?

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
Mar 14 '09 #1
2 12265
amitpatel66
2,367 Expert 2GB
Check here for detail
Mar 16 '09 #2
thanks dude, I appreciate it...
AJ
Mar 17 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by sudhaoncyberworld | last post: by
28 posts views Thread by Giggle Girl | last post: by
reply views Thread by zattat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.