Is there a way to add db specific hints to Brio queries.
I'm looking to improve the performance of a bunch of brio reports that connect to a MS SQL database to pull data. Brio seems to be creating SQL queries with not hints like
WITH (NOLOCK)
This leads to these generated select queries blocking updates to the table. So is there a way to make Brio add the WITH (NOLOCK) hint to SQL queries?