Tag Info

New answers tagged

10

Are multicolumn histograms possible? Not true multi-dimensional histograms, no. Is this artificial and inelegant solution the only available option to achieve accurate estimations when dealing with filtering by two or more not independent columns? SQL Server does support "multi-column" statistics, but they only capture average density ...


7

...SSMS is not running this using sp_execute so I don't think this is being caused by parameter sniffing. What are the possible causes for this behavior? The optimizer cannot 'sniff' the values of local variables, so the cardinality estimate is based on a guess. If you are using the original cardinality estimator, the fixed guess for BETWEEN is 9% of ...



Top 50 recent answers are included