execution-plan Archives - Page 2 of 92

MySQL slow query log to identify queries that scan tables

By adminPosted on January 27, 2023

Question : MySQL seems not to have setting to show you queries that use SOME indexes but still also do […]

By adminPosted on January 27, 2023

Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]

By adminPosted on January 26, 2023

Question : I’m using the below T-SQL to check for root level estimate skews in execution plans by pulling the […]

By adminPosted on January 25, 2023

Question : Here’s part of an EXPLAIN ANALYZE from Postgres 9.6: -> Bitmap Heap Scan on cities (cost=90.05..806.49 rows=265 width=4) […]

By adminPosted on January 23, 2023

Question : I need help in improving very poor query performance. Query SELECT DISTINCT ROW_NUMBER () over (order by WR.WPIS_ID) […]

By adminPosted on January 22, 2023

Question : We recently upgraded from SQL Server 2008R2 to SQL Server 2014 SP1 + CU4. After a couple of […]

By adminPosted on January 22, 2023

Question : create table T(ID int identity primary key) insert into T default values insert into T default values go […]

By adminPosted on January 21, 2023

Question : I have been trying to figure out how to scan a stored procs parameters from the execution plan. […]

By adminPosted on January 19, 2023

Question : I have captured an actual query plan for a specific query. After this I’ve changed a few things […]

By adminPosted on January 19, 2023

Question : My database contains a specific table that is quite large (250+M rows, 100+GB data space). Generating a clustered […]