Tag: cardinality-estimates

Found 57 results for 'cardinality-estimates'.

1) postgresql - Postgres prefers slow Seq Scan over fast Index Scan
2) sql-server - What Method / Formula does a Nested Loops Operator use for row estimation?
3) sql-server - Estimated vs. Actual Row counts in a trivial case
4) sql-server - Type conversion in expression may affect “CardinalityEstimate” - on a computed column?
5) sql-server - Histogram Skew on Clustered Index
6) sql-server - Datetime to formatted Date Implicit Conversion
7) sql-server - How to correct row estimates due to join of 2 well-estimated results
8) sql-server - How do I effectively handle very skewed data? Statistics up to date but don't seem to help
9) sql-server - How does SQL Server's optimizer estimate the number of rows in a joined table?
10) sql-server - Warning in query plan "Cardinality Estimate"
11) sql-server - Wrong estimate on a query on partitioned tables
12) sql-server - Update statistics on sys.objects
13) sql-server - Why does a DELETE query run in one format much longer than in another?
14) sql-server - Ascending keys getting bad plans in SQL 2016 (new CE), replacement for TF 4139 et al.?
15) sql-server - SQL Server 2014: any explanation for inconsistent self join cardinality estimate?
16) sql-server - Type conversion in expression may affect "CardinalityEstimate" in query plan choice?
17) sql-server - Why is this join cardinality estimate so large?
18) sql-server - Why does SQL Server estimate less rows will be emitted from a join after inserting some rows?
19) sql-server - Improving statistics on a large "WHERE IN" SQL Server query
20) sql-server - Does WITH SCHEMABINDING on a multi-statement TVF improve cardinality estimates?
21) sql-server - How do cardinality estimates affect CPU and Reads in SQL Server?
22) query-performance - Bad estimates when sorting, good estimates without sort
23) postgresql - How to improve the estimated cardinality of inner join lateral
24) sql-server - Cardinality estimate outside the histogram
25) sql-server - What makes for a good index in this scenario?
26) sql-server - Conversion may affect "CardinalityEstimate" CONCAT NVARCHAR and UNIQUEIDENTIFIER
27) sql-server - How to improve row estimate of 1 row in join for newly inserted data
28) sql-server-2016 - SQL Server 2016 Compatibility Level and Datetime 2
29) sql-server - Query 100x slower in SQL Server 2014, Row Count Spool row estimate the culprit?
30) query-performance - Badly-formed histogram causes bad estimates on Nested Loop
31) mysql - A low cardinality column index and SELECT
32) sql-server - How does the optimizer treat yet-unpopulated #temp tables when estimating cardinality?
33) postgresql - Improving distinct values estimates in Postgres
34) sql-server - Cardinality Estimate for LIKE operator (Local Variables)
35) sql-server - Estimated Rows Higher than Actual Despite Updating Statistics
36) sql-server - Query with Variable not estimating right
37) sql-server - Why does Concatenation operator estimate fewer rows than its inputs?
38) sql-server - Hash join between master/detail tables produces too-low cardinality estimate
39) sql-server - Сardinality estimation of partially covering range predicates
40) sql-server - Inserting with implicit type conversion causes warning for cardinality estimates
41) sql-server - How to hint many-to-many join in SQL Server?
42) database-design - Implement a two sided zero to many relationship?
43) sql-server - Apply cardinality estimation problem in SQL Server
44) sql-server - Nested Loop has very low estimates due to skewed data
45) sql-server-2014 - When do _WA_Sys_ statistics Get Updated?
46) sql-server - Sort spills to tempdb but estimated rows equals to actual rows
47) sql-server - SQL server 2012 inner join estimated number of rows issue
48) sql-server - Why does Recursive CTE estimate just 1 row?
49) sql-server - Bad row estimate following Compute Scalar operator in plan
50) sql-server - Alternative for WHERE clause in SQL query