cancel
Showing results for 
Search instead for 
Did you mean: 

Unsed Index

Former Member
0 Kudos

Hi,

Our database size is more than 2.5 TB. We nee find out unused indexes from the database.

Kindly guide accordingly.

Thanks in advacne.

Regards,

Rahul.

Accepted Solutions (1)

Accepted Solutions (1)

JPReyes
Active Contributor
0 Kudos

Funny, you forgot to mention what DB are you using....

Also theres lots of information about this on the web... Did you search before posting?

Regards

Juan

Answers (2)

Answers (2)

former_member475159
Participant
0 Kudos

Hi Rahul,

Please check the below link

http://www.saptechies.com/faq-index-fragmentation/

Thanks

Debdeep

Former Member
0 Kudos

Hi Juan,

The db is oracle 10.2.0.4. We checked there are lots of .sql are avaialble.

But we are also interested for any SAP specific programs or any note for the same.

Inconvenience is deeply regretted.

Regards,

Rahul.

JPReyes
Active Contributor
0 Kudos

Read,

SAP Note 974781 - Oracle database 10g: Internal maintenance jobs

SAP Note 927813 - Oracle 10g: Using Oracle Segment Advisor to optimize space

Regards

Juan