Tag: execution-plan

Found 349 results for 'execution-plan'.

1) postgresql - Do databases optimize repeated similar query params on the same column?
2) postgresql - Inconsistent statistics on jsonb column with btree index
3) postgresql - Slow fulltext search due to wildly inaccurate row estimates
4) mysql - I am unable to join tables in correct manner
5) mysql - Deciding which MySQL execution plan is better
6) postgresql - Why does this LEFT JOIN perform so much worse than LEFT JOIN LATERAL?
7) sql-server - Updating a table efficiently using JOIN
8) postgresql - postgresql operator negator usage
9) sql-server - Why doesn’t this recursive CTE with a parameter use an index when it does with a literal?
10) postgresql - Suboptimal plan when joining on an ID column with incorrect statistics
11) postgresql - Why does PostgreSQL perform a seq scan when comparing a numeric value with a bigint column?
12) postgresql - PostgreSQL partial index unused when created on a table with existing data
13) postgresql - Postgres prefers slow Seq Scan over fast Index Scan
14) postgresql - Index that is not used, yet influences query
15) postgresql - Multi-expression indexes in PostgreSQL not using being used as expected
16) sql-server - Actual rows read in a table scan is multiplied by the number of threads used for the scan
17) sql-server - Why is the secondary selective index not used when the where clause filters on `value()`?
18) sql-server - SHOWPLAN does not display a warning but "Include Execution Plan" does for the same query
19) sql-server - Execution time high for Query in sp_executesql
20) sql-server - Row estimates always too low
21) sql-server - Why is selecting all resulting columns of this query faster than selecting the one column I care about?
22) postgresql - Have Postgresql query planner use nested loop w/ indices over hash join
23) sql-server - Inconsistent Execution Plan for Stored Procedure
24) sql-server - Execution time of a stored procedure
25) mysql - MySQL Stored Procedure - no of times executed
26) sql-server - OPTIMIZE FOR UNKNOWN in a Stored Procedure
27) postgresql - Creating multicolumn index for WHERE and ORDER BY
28) postgresql - Query plan for a dynamically built `query_int` using `format()`
29) sql-server - Estimated Operator Cost Calculation
30) sql-server - What is BMK Operator in SQLServer
31) postgresql - How to use index for simple time range join?
32) sql-server - Index on Persisted Computed column needs key lookup to get columns in the computed expression
33) execution-plan - Graphical Actual Execution Plan - Estimated vs Actual number of rows
34) sql-server - What is causing high CPU usage from this query/execution plan?
35) postgresql - postgresql sticking "enable_seqscan=False" in a UDF sensible?
36) sql-server - View columns elimination
37) sql-server - Two columns with and without index in where clause - How index works
38) postgresql - Postgres not using index in citext column
39) sql-server - CROSS APPLY produces outer join
40) sql-server - Index Seek Operator Cost
41) sql-server - What does Nested Loops join operator has to do with a Scalar?
42) sql-server - How to regenerate execution plans after clearing the plan cache?
43) sql-server - SQL Server - Prevent Clustered Index Scan on a specific table
44) sql-server - Why are the majority of cached plans missing from sys.dm_exec_query_stats?
45) postgresql - Joining a function and a view
46) sql-server - SQL Server Index Scan Actual Executions
47) postgresql - Postgres chooses seq scan over index scan
48) sql-server - Getting a realistic query plan when partitioning with low volumes of data
49) postgresql - Why does COALESCE prevent the use of an index on a varchar, but not on a text column?
50) postgresql - How to get more physical details when executing an SQL query?