How to disable query from using BIA???

[Former Member]

Hey geniuses,

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.

Jennifer

[Former Member · Accepted solution]

Hi Jennifer,

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.

Regards,

Praveen

[Vitaliy-R · Accepted solution]

Praveen, you are right about the note. I was not awake yet

Cheers,

-Vitaliy

[Former Member]

Thanks all, you are great!

[Vitaliy-R]

Hi, genius.

Use program code from the OSS Note 1180279

Regards,

-Vitaliy