cancel
Showing results for 
Search instead for 
Did you mean: 

Interpreting results of DB05 transaction

Former Member
0 Kudos

Hi,

Does anybody has idea how to interpret the results of DB05 analysis of table with respect to index fields. Based on its output is it possible that we can find out the feasibility to create new index fields on the table or not ? ie

I have a table t1 and it has fields f1 f2 f3 f4. we have an sql in which where clause is used on fields f3 and f4. There are no indexes for f3 and f4 which is degrading the sql performance. now i want to create indexes for fields f3 and f4. So in this case can i use :

  • db05 transaction to find out the feasibility of creating indexes on f3 and f4.

  • how to interpret the results of db05 transaction after i do an analysis of fields f3 and f4.

  • if i cannot use db05, what are the other options available.

Expecting helpful replies.

Regards,

Sandy

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member239282
Active Participant
0 Kudos

hi Sandeep

you can check the Wiki page:

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

best regards,

P.