Home » RDBMS Server » Performance Tuning » which view to use to know about global partitioned index
which view to use to know about global partitioned index [message #123756] Tue, 14 June 2005 13:38 Go to next message
tom_k_mishra
Messages: 3
Registered: June 2005
Junior Member
As of my understanding, we can make both local and global partitioned index on a partitioned table.the global partitioned index has to be prefixed. If we query the user_indexes:

select index_name, table_name, index_type, partitioned from ind;

If the index_types come as normal and partitioned=yes then we know it is a regular Btree index but how we know it is whether local or global type. Is there any other dictionary view to look for.

thanks.

Report message to a moderator

Re: which view to use to know about global partitioned index [message #123759 is a reply to message #123756] Tue, 14 June 2005 14:00 Go to previous message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
Check out user_part_indexes

Report message to a moderator

Previous Topic: SQL QUERY NOT USING BITMAP INDEX
Next Topic: Which parameter?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 24 04:14:37 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.