Home » RDBMS Server » Performance Tuning » How to find Local and global indexes on Particular Table (Oracle 10g Release 2)
How to find Local and global indexes on Particular Table [message #547933] Mon, 19 March 2012 02:05 Go to next message
msol25
Messages: 396
Registered: June 2011
Senior Member
Please help for getting how many local and global indexes on particular oracle table


Thanks & Regards
Saurabh

Report message to a moderator

Re: How to find Local and global indexes on Particular Table [message #547940 is a reply to message #547933] Mon, 19 March 2012 02:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
user/all/dba_part_indexes.locality

Regards
Michel

Report message to a moderator

Re: How to find Local and global indexes on Particular Table [message #547948 is a reply to message #547940] Mon, 19 March 2012 03:12 Go to previous message
msol25
Messages: 396
Registered: June 2011
Senior Member
Thanks Michel!!!

Report message to a moderator

Previous Topic: Reading AWR
Next Topic: Materialized View, which should refresh every Tuesday and Friday at 5am. (merged 2)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 15:52:27 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.