Regarding Indexes and performance tuning.

[Former Member]

Hi Everyone,

I need some elaborate explanation about indexes and performance tuning.

1. How do you find out whether the select query which I write is utilizing the indexes .

2. Is it true that the sequence in which the indexes are defined in se11

for eg: MANDT

KNUMH

KOPOS

your select query should also have the same sequence in the where clause else the indexes are not utilized well .

3. Is there any precautions/ special method to write select queries for proper utilization of indexes.

Thanks to all reading and answering in advance.

Rgds,

Anu.

[Former Member]

Hi Everyone,

I need some elaborate explanation about indexes and performance tuning.

1. How do you find out whether the select query which I write is utilizing the indexes .

2. Is it true that the sequence in which the indexes are defined in se11

for eg: MANDT

KNUMH

KOPOS

your select query should also have the same sequence in the where clause else the indexes are not utilized well .

3. Is there any precautions/ special method to write select queries for proper utilization of indexes.

Thanks to all reading and answering in advance.

Rgds,

Anu.

[Former Member]

Hi

You will find like this

If your select like this

select matnr mtart from mara into<itab>

where matnr = <>..

Go to table and see mara ..if matnr is checked as primary key,then you are using primary index.

Check secondary index tab and see if any fields,if those fields you are using in select then you are using secondary index.

2.Not sequence,check how many fields are checked tick as primary key,all thsoe are index.

3.Always try to use proper primary index in select statment and avoid nested select statements.

Thanks

[Former Member]

Hi,

you can use SQL Trace (ST05 ) to chechk how your select work .

also see SE30 for performance tuning.

regards

deepak.