on 07-07-2007 4:56 AM
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
hi Sandeep
you can check the Wiki page:
https://www.sdn.sap.com/irj/sdn/wiki?path=/display/maxdb/transaction%2bdb05
best regards,
P.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.