OraFAQ Forum: Performance Tuning » which view to use to know about global partitioned index

Home » RDBMS Server » Performance Tuning » which view to use to know about global partitioned index

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

which view to use to know about global partitioned index [message #123756]

Tue, 14 June 2005 13:38

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 10:38:06 CDT 2025