Cardinality Estimator

A Hard Working DBA and Much More

Home: Welcome

Nov 1, 20211 min read

How CE Change Should Impact SQL Queries By Examples Part 9: Implicit Data Type Conversions

Part1, Part2, Part3, Part4, Part5, Part6, Part7, Part8 Case 8: New CE assume larger number of rows from implicit data type conversions...

0 comments

Nov 1, 20212 min read

How CE Change Should Impact SQL Queries By Examples Part 8: Distinct Value Count

Part1, Part2, Part3, Part4, Part5, Part6, Part7, Part9 Case 7: New CE changes distinct value count estimation For queries where...

0 comments

Nov 1, 20212 min read

How CE Change Should Impact SQL Queries By Examples Part 7: Base or Simple Containment

Part1, Part2, Part3, Part4, Part5, Part6, Part8 , Part9 Case 6: New CE use "base containment" instead of "simple containment" The CE...

0 comments

Nov 1, 20212 min read

How CE Change Should Impact SQL Queries By Examples Part 6: Complex Join Condition

Part1, Part2, Part3, Part4, Part5, Part7, Part8 , Part9 Case 5: New CE simplify the calculation for complex join condition With more...

0 comments

Home: Blog2

Home: Subscribe

CONTACT

500 Terry Francois Street San Francisco, CA 94158

123-456-7890

Home: Contact