Skip to Content
-3
Jun 24, 2020 at 09:10 AM

Performance issue of Z Report

172 Views

We have reports which are too slow.

These reports are based on Two z tables which having records more than 8 lacs and vekp table.

The two z table need to access without primary keys. Say need to access both the Z tables with select query which contains non primary keys . But the reports contains more than 6 select option parameters which are based on primary fields and non primary fields.

What factors can increase the output performance ?

like select query paremeter/select-options sequence or index etc.

Second have to access the vekp table based on erdat which is non primary key. its taking too long time .