Report performance issue

[pranita.avhad]

Hello,

Please give me suggestions about,
what all points that need to take care of while writing suppose inventory report
in MFG/PRO to avoid the performance issue?

Thanks in advance.

 

[kishorchari]

Which version?
Use maximum selection to get best performance.

 

[pranita.avhad]

Thanks for the reply.

Actually i m trying to improve the query performance where tr_hist, trgl_hist tables are included.
so can u plz help me on how to improve the query performance

 

[kishorchari]

These are two bulky tables accept key index fields in selection (must). What ver?