Question : This question already has answers here: Why is my query suddenly slower than it was yesterday? (4 answers) […]
Tag: execution-plan
SQL Server cached an execution plan which is not optimal in some cases and uses it for all consequent queries
Question : Our application uses SQL Server 2014 and we got an issue related to the plan cache. We have […]
Is there any way to find the number of pages read by each operator in query plan?
Question : I need to find number of pages scanned by the operator in a sql-server query plan. I used […]
Have Postgresql query planner use nested loop w/ indices over hash join
Question : I’m having a problem with some StackOverflow-schema related data loaded into PostgreSQL 9.3.4. I have a query that […]
Operator used tempdb to spill data during execution with spill level 2
Question : I am struggling to minimise the cost of sort operation on a query plan with the warning Operator […]
Why is my index on the join keys not used in a very simple hash join case?
Question : I have two tables: create table animal ( aid integer, cid integer, aname varchar(255) default NULL::character varying, species […]
Eliminate key lookup in execution plan
Question : I have the following query: DECLARE @p__linq__0 UNIQUEIDENTIFIER SET @p__linq__0 = ‘… some guid …’ SELECT TOP 1 […]
Very slow query despite index being used
Question : I have this table, created to hold tons of modbus measurements that comes from my devices: CREATE TABLE […]
Why is TOP operation in SQL execution plan
Question : After searching for a while, I decided to post this question for lack of finding an answer and […]
Is it possible to tell if a database has AUTOMATIC_TUNING switched on?
Question : In SQL Server 2017 is it possible to tell if automatic tuning is switched on? This relates to […]