How to disable query from using BIA???
since I've tested some of our queries are not very BIA fans, still costing a lot of db time, do u know how to find the switch that provents query from using BIA index? Hurry up!
thanks in advance.
Praveen Kumar Jaggasa replied
To prevent a specific query from accessing BIA, you need to set the indicator "NOHPA" in the table RSRREPDIR for that particular query. You can use the program given in note 1161525 for that purpose.
I think Vitaliy also wanted you to refer to this note.