Unused Indexes - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Unused Indexes

  1. #11
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    If you have Oracle Enterprise Manager with Diagnostic Pack which includes Oracle Expert, this will generate a report which would recommend where you have to delete unused indexes, where you need to add index (this is just a little part of report)etc etc . I believe you can download OEM from technet so diagnostic pack.


  2. #12
    Join Date
    Nov 2000
    Posts
    344

    Lightbulb

    There is another tool which I wrote called EZSQL (www.ezsql.net) which will go through the sql statements in v$SQLAREA and analyze them, and figure out which indexes have been used and which ones have not. You can set up some filters so it doesn't analyze everything in V$SQLAREA, just the ones you want...


  3. #13
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Oracle Expert goes through v$sqlarea as well.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width