topic Re: Regarding Indexes in Application Development and Automation Discussions

Regarding Indexes

Former Member — Sat, 01 Feb 2014 05:07:44 GMT

Hi,

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

Regards

Saritha

Former Member — Sat, 01 Feb 2014 05:30:42 GMT

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 — Sat, 01 Feb 2014 05:50:27 GMT

Sai Ganesha,

Can you elaborate better on your requirement?

gouravkumar64 — Sat, 01 Feb 2014 06:03:17 GMT

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.

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

Hope this will help you.

Thanks

Gourav.

former_member187748 — Sat, 01 Feb 2014 06:05:57 GMT

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.