Forum Discussion
LuITS
Helper II
Helper IIDirect Query: Slow Performance
Hallo, i need help optimiszing my direct query report and the datasource. I have two Tables, one Facttable with lot of collumns but only 15k rows and i have table acces for row level security. F...
Use Performance Analyzer to capture the direct query that is produced by your visual. Examine that query and run it directly on your Azure database. Examine the query execution plan and follow the suggestions on which index would be suitable for that query.
lbendlin
Super User
Super UserUse Performance Analyzer to capture the direct query that is produced by your visual. Examine that query and run it directly on your Azure database. Examine the query execution plan and follow the suggestions on which index would be suitable for that query.