Regarding Indexes

[Former Member]

Hi,

Can anyone tell me,How can we find out is anything missing in already existing Indexes.

Regards

Saritha

[Former Member]

Hi Saritha,

I hope you are talking about indexes in database tables.

Indexes are created based on the data and it's fetching fields so just by looking you can not identify what is missing.

Regards

Bikas

[Arun_Prabhu_K]

Sai Ganesha,

     Can you elaborate better on your requirement?

[gouravkumar64]

Hi Sai ganesha,

If I am not wrong,you are trying to check index properly done or not & if there is some missing index or not.

So better to Go with these 2 ways.

1) Check whether index using or not.

You have to check by SQL Trace-ST05 with se38.

This link will help you.

Indexing in SAP Tables - Community Profiles - SCN Wiki

2) For missing index checking you can also use CCMS monitoring WITH db02 from BASIS ,

Checking for Missing Indexes (SAP Library - BC R/3 Database Guide: MS SQL Server)

Hope this will help you.

Thanks

Gourav.

[former_member187748]

Hi Sai,

as i am not getting your queries throughly, so here i am sujjesting you to go through this help

links, you might get some help, otherwise please elaborate your problem at some details.

Consistency Checks - Monitoring in the CCMS - SAP Library

Consistency Checks (SAP DB) (SAP Library - CCMS Monitoring)

Checking Consistency of the Database (SAP Library - BC R/3 Database Guide: MS SQL Server)