Question : Which statement is correct about the parallel executions plan? A. The CUSTOMERS and SALES tables are scanned simultaneously […]
Query performance on different servers
Question : Same query with select and where clause is less than 2 seconds on one server and same query […]
Sort operator positioning in an execution plan
Question : I am troubleshooting a performance issue and trying to get a stable execution plan for a reporting query. […]
Turn off auto qualification of table names when creating a view
Question : Problem Definition I am trying to modified a shared development database, for a dev team to use for […]
Why query cache plan kept dynamic queries but not sp?
Question : My company has some legacy system that uses quite a lot of dynamic queries (no parameters). In the […]
Is it worth to optimize queries with EarlyTermination Timeout?
Question : Right after running Ola’s IndexOptimize to rebuild all indexes and statistics, I cleared the data and plan cache […]
Why does SQL Server use a better execution plan when I inline the variable?
Question : I have a SQL query that I am trying to optimize: DECLARE @Id UNIQUEIDENTIFIER = ‘cec094e5-b312-4b13-997a-c91a8c662962’ SELECT Id, […]
How does NHibernate handle execution plan?
Question : I heard from a podcast that there are no ORMs that have a good solution for execution plan […]
Optimizing “random” choice in PostgreSQL
Question : I have the following table CREATE TABLE article ( id bigserial PRIMARY KEY, text TEXT NOT NULL, category_id […]
Query taking too much time
Question : My query is taking too much time to execute. Please help me here. mysql> explain select pcm.catalog_id from […]