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 .