After our rolling out process for accelerator, we noticed that there were some cases the query did not use BWA indexes for the InfoCube. We saw these statistics in the BWA_TOOLKIT which is a support tool from SAP under the Note: 1517326.
I am wondering what are the cases that BEX Query decide not to use BWA indexes.
After we rolled out the accelerator, we had 905 times where BWA Used and 239 where BWA Not Used.
I will appreciate any ideas here.