| Global and Local Index [message #164918] |
Mon, 27 March 2006 10:31  |
toshidas2000
Messages: 120
Registered: November 2005
|
Senior Member |
|
|
I have a partition table, there are indexes on this table, how do I find, which one is local and global index.
Thanks
Toshi
|
|
|
|
| Re: Global and Local Index [message #164977 is a reply to message #164918] |
Mon, 27 March 2006 22:17  |
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
|
Senior Member |
|
|
A partitioned index will have an entry in USER_PART_INDEXES. If the index does not exist in this view, then it is a GLOBAL NON-PARTITIONED index.
This does not mean that all indexes in USER_PART_INDEXES are LOCAL; some may be GLOBAL PARTITIONED. You have to look at the LOCALITY column.
Ross Leishman
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
