Home » RDBMS Server » Performance Tuning » Global and Local Index
- Global and Local Index [message #164918] Mon, 27 March 2006 10:31 Go to next message
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

Report message to a moderator

- Re: Global and Local Index [message #164977 is a reply to message #164918] Mon, 27 March 2006 22:17 Go to previous message
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

Report message to a moderator

Previous Topic: Materialized View Based on a Union Query
Next Topic: oracle solaris tuning kernel
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 01 20:28:40 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.