Skip to Content
0
Former Member
Jul 07, 2007 at 03:56 AM

Interpreting results of DB05 transaction

34 Views

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