Question : This question already has answers here: When To Update Statistics? (2 answers) Closed 2 years ago. I have […]
Tag: recompile
Why does SQL Server not perform constant (UNION ALL) branch elimination with OPTION(RECOMPILE) when selecting the result into a scalar variable?
Question : We use some ‘aggregate’ views to select from multiple tables using a discriminator (note: these views are not […]
utlrp.sql fails to execute
Question : I just created a docker image of Oracle 11g ee following this tutorial https://vitalflux.com/how-to-install-oracle-11g-ee-on-docker/ and loaded some tables […]
Execution plan with a lot of ComputeScalar operations
Question : I executed the same query with and without OPTION (RECOMPILE). When I compare the 2 plans, visually the […]
Execution plan with a lot of ComputeScalar operations
Question : I executed the same query with and without OPTION (RECOMPILE). When I compare the 2 plans, visually the […]
Compile Dynamic Sql before Running
Question : I have a table, and want to test if dynamic sql will compile. Example: create Table dbo.Product ( […]
SQL Server Execution Plan on server level
Question : Case: I have application which is doing search from database. That is going very slowly (more than 40 […]
Why does SQL Server not perform constant (UNION ALL) branch elimination with OPTION(RECOMPILE) when selecting the result into a scalar variable?
Question : We use some ‘aggregate’ views to select from multiple tables using a discriminator (note: these views are not […]