Tweeted twitter.com/StackDBAs/status/847837440387797001
4 Formatting
source | link

Is there a way how to 'inject' a cardinality estimation to a SQL Server optimizer (any version)?

i.e. something similar to Oracle's cardinality hint.

My motivation is driven by the article ', How Good Are Query Optimizers, Really?'[1], where they test the influence of the cardinality estimator on a selection of a bad plan. Therefore, it would be sufficient if I could force the SQL Server to 'estimate' the cardinalities precisely for complex queries.

 

[1] Leis, Viktor, et al. "How good are query optimizers, really?"How good are query optimizers, really?".
   Proceedings of the VLDB Endowment 9.3 (2015): 204-215.  

Is there a way how to 'inject' a cardinality estimation to a SQL Server optimizer (any version)?

i.e. something similar to Oracle's cardinality hint.

My motivation is driven by the article 'How Good Are Query Optimizers, Really?', where they test the influence of the cardinality estimator on a selection of a bad plan. Therefore, it would be sufficient if I could force the SQL Server to 'estimate' the cardinalities precisely for complex queries.

Leis, Viktor, et al. "How good are query optimizers, really?".
 Proceedings of the VLDB Endowment 9.3 (2015): 204-215.  

Is there a way how to 'inject' a cardinality estimation to a SQL Server optimizer (any version)?

i.e. something similar to Oracle's cardinality hint.

My motivation is driven by the article, How Good Are Query Optimizers, Really?[1], where they test the influence of the cardinality estimator on a selection of a bad plan. Therefore, it would be sufficient if I could force the SQL Server to 'estimate' the cardinalities precisely for complex queries.

 

[1] Leis, Viktor, et al. "How good are query optimizers, really?"
  Proceedings of the VLDB Endowment 9.3 (2015): 204-215.

3 added 1 character in body
source | link

Is there a way how to 'inject' a cardinality estimation to a SQL Server optimizer (any version)?

i.e. something similar to Oracle cardinality hint.

i.e. something similar to Oracle's cardinality hint.

My motivation is driven by the article 'How Good Are Query Optimizers, Really?', where they test the influence of the cardinality estimator on a selection of a bad plan. Therefore, it would be sufficient if I could force the SQL Server to 'estimate' the cardinalities precisely for complex queries.

Leis, Viktor, et al. "How good are query optimizers, really?".
Proceedings of the VLDB Endowment 9.3 (2015): 204-215.

Is there a way how to 'inject' a cardinality estimation to a SQL Server optimizer (any version)?

i.e. something similar to Oracle cardinality hint.

My motivation is driven by the article 'How Good Are Query Optimizers, Really?', where they test the influence of the cardinality estimator on a selection of a bad plan. Therefore, it would be sufficient if I could force the SQL Server to 'estimate' the cardinalities precisely for complex queries.

Leis, Viktor, et al. "How good are query optimizers, really?".
Proceedings of the VLDB Endowment 9.3 (2015): 204-215.

Is there a way how to 'inject' a cardinality estimation to a SQL Server optimizer (any version)?

i.e. something similar to Oracle's cardinality hint.

My motivation is driven by the article 'How Good Are Query Optimizers, Really?', where they test the influence of the cardinality estimator on a selection of a bad plan. Therefore, it would be sufficient if I could force the SQL Server to 'estimate' the cardinalities precisely for complex queries.

Leis, Viktor, et al. "How good are query optimizers, really?".
Proceedings of the VLDB Endowment 9.3 (2015): 204-215.

2 added 25 characters in body
source | link

Is there a way how to 'inject' a cardinality estimation to a SQL Server optimizer (any version)? i.e. something similar to Oracle cardinality hint.

i.e. something similar to Oracle cardinality hint.

My motivation is driven by the article 'How Good Are Query Optimizers, Really?'How Good Are Query Optimizers, Really?' [1], where they test the influence of the cardinality estimator on a selection of a bad plan. Therefore, it would be sufficient if I could force the SQL Server to 'estimate' the cardinalities precisely for complex queries.

[1]: Leis, Viktor, et al. "How good are query optimizers, really?. "How good are query optimizers, really?" Proceedings.
Proceedings of the VLDB Endowment 9.3 (2015): 204-215. https://www.researchgate.net/profile/Peter_Boncz/publication/305253105_How_Good_Are_Query_Optimizers_Really/links/5852763d08ae95fd8e1d4495.pdf

Is there a way how to 'inject' a cardinality estimation to a SQL Server optimizer (any version)? i.e. something similar to Oracle cardinality hint. My motivation is driven by the article 'How Good Are Query Optimizers, Really?' [1], where they test the influence of the cardinality estimator on a selection of a bad plan. Therefore, it would be sufficient if I could force the SQL Server to 'estimate' the cardinalities precisely for complex queries.

[1]: Leis, Viktor, et al. "How good are query optimizers, really?." Proceedings of the VLDB Endowment 9.3 (2015): 204-215. https://www.researchgate.net/profile/Peter_Boncz/publication/305253105_How_Good_Are_Query_Optimizers_Really/links/5852763d08ae95fd8e1d4495.pdf

Is there a way how to 'inject' a cardinality estimation to a SQL Server optimizer (any version)?

i.e. something similar to Oracle cardinality hint.

My motivation is driven by the article 'How Good Are Query Optimizers, Really?', where they test the influence of the cardinality estimator on a selection of a bad plan. Therefore, it would be sufficient if I could force the SQL Server to 'estimate' the cardinalities precisely for complex queries.

Leis, Viktor, et al. "How good are query optimizers, really?".
Proceedings of the VLDB Endowment 9.3 (2015): 204-215.

1
source | link