Skip to Content
Former Member
Feb 22, 2006 at 08:05 AM

Performance tuning of a report.


hello all,

I have been assigned a report to improve the performance.Initially after studying the report i found that all the data was fetched by using select * from... query,hence i changed the query by selectin the particular feilds from the tables.the tables used in my report r bsid and bsad majorly..after these changes there was not much of a diff in the performance,after tracing the report thru st05 it was realized that the select for bsad is taking the max time to bsad is a huge table and has huge amount of ther any way i can reduce this using indexes n all..can u please provide me with an example to reduce the time taken for fetchin data from bsid and bsad..

thanks and regards,