optimization – Azure SQL Query Performance Degradation when Row Level Security is ON
In Azure SQL database, the same query is completed in 4 seconds when Row Level Security is active, and in 1 second when Row Level Security is disabled.
When I compared the execution plans of the queries, I found that the optimizer could not use parallelism when Row Level Security was active. You can see the below screenshot.
My questions are;
1- Is it technically possible for the optimizer to use parallelism when Row Level Security is active?
2- If possible, what should I do to make the optimizer use parallelism even when Row Level Security is active?
Read more here: Source link

