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.