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: 234
Registered: June 2011
Location: Mumbai
Senior Member
Please help for getting how many local and global indexes on particular oracle table


Thanks & Regards
Saurabh
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: 60069
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
user/all/dba_part_indexes.locality

Regards
Michel
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: 234
Registered: June 2011
Location: Mumbai
Senior Member
Thanks Michel!!!
Previous Topic: Reading AWR
Next Topic: Materialized View, which should refresh every Tuesday and Friday at 5am. (merged 2)
Goto Forum:
  


Current Time: Mon Dec 29 08:37:53 CST 2014

Total time taken to generate the page: 0.08819 seconds