Hi,
There is a report doing querry on KNVV and taking 93% of the database time. It retreives around 3 lacs records form this table and sometimes give time out error also.
All the primary keys are meeting and all required fields are getting selected from the table.
Is there any way out to improve the performance in this case. Would it be a good idea to create a secondary index on this table.
I would really appriciate if any one can help me out on this.
Many thanks in Advance.
Regards
Ria