Working of DB05 Transaction

[Former Member]

Hi,

Can anyone explain the working of DB05 transaction, interpretation of the results after analysis and in what situations is it useful?

We have identified few expensive SQL statements and reading the Where clause we have concluded to create new indexes for the table using Where clause fields.

I would like to know if DB05 could be of any help and how ?

Thanks in advance for the reply.

Regards,

Sandeep.

[vincentlim826 · Accepted solution]

I agree that there is not much documentation about DB05.

DB05 allows you to carry out an anlyse for the table in respect to the

index fields. You can look at the job results in SM37 - job name

is TABLE_ANALYSIS_<NAME>.

It's using program RSDB0005. Maybe you can go to SE38, and study through the abap code.

ST03/ST04/ST05 are good tools for expensive SQL statement.

Are you looking on how to fine tune the expensive sql statement ?

cheers,

Vincent

[Former Member · Accepted solution]

Hi,

Thanks for your answers. I know the transactions ST04, St05 which would be helpful in identifying expensive sql stmts.

I have identified a few of those. Now I would like to know if its feasible to create indexes for the sql where clause for faster access. We can use DB05 transactions which helps in analysis of the table with respect to the index fields.

I would like to get some more information as how to interpret the results that we obtain from DB05 execution to go ahead with the index generations.

Regards,

Sandeep.

[Satyabrata_Basu]

Hi Sandeep,

Pls check the Wiki page:

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/maxdb/transaction%2bdb05

although it's mentioned for MaxDB, it's valid for other database platform too..

Cheers !!

Satya.

PS: pls reward points if the answer was helpful..thx

[Former Member]

Hi Satya,

Thanks for the reply. However before posting this thread I had read that. but could not get much information from there.

Please let me know if there are any other sources..

Regards,

Sandeep.