Improve Query Run time

[Former Member]

Hello,

I want to know if there is an option of creating indexes over BIA indexes.

I tried to find related information on SDN but could not find any.

However there were suggestions about other ways of enhancing the queries that are already on BIA and are still slow.

These included usage of precalculated queries, use of SAP exits rather than Customer exits and others.

Also there were some SAP notes that talked about implementing a patch.

Is there something that anyone knows and could be helpful.

Will reward points even for a helpful answer.

Regards

Sakshi

[former_member112305 · Accepted solution]

Hi Sakshi,
There is no option for creating indexes over  BIA indexes.
You can try to analyse query performance following the note below:
1871604 - BWA Troubleshooting: Analyse poor query performance.

Best Regards,

Shivanagouda Ningodti

[Former Member · Accepted solution]

Thanks for your inputs Shiva.