The Community for Technology Leaders
2013 IEEE 29th International Conference on Data Engineering (ICDE) (2010)
Long Beach, CA, USA
Mar. 1, 2010 to Mar. 6, 2010
ISBN: 978-1-4244-5445-7
pp: 1072-1080
Ravishankar Ramamurthy , Microsoft Corp, One Microsoft Way Redmond WA, USA
Surajit Chaudhuri , Microsoft Corp, One Microsoft Way Redmond WA, USA
Vivek Narasayya , Microsoft Corp, One Microsoft Way Redmond WA, USA
Leo Giakoumakis , Microsoft Corp, One Microsoft Way Redmond WA, USA
ABSTRACT
Many modern optimizers use a transformation rule based framework. While there has been a lot of work on identifying new transformation rules, there has been little work focused on empirically evaluating the effectiveness of these transformation rules. In this paper we present the results of an empirical study of “profiling” transformation rules in Microsoft SQL Server using a diverse set of real world and benchmark query workloads. We also discuss the implications of these results for designing and testing query optimizers.
INDEX TERMS
CITATION
Ravishankar Ramamurthy, Surajit Chaudhuri, Vivek Narasayya, Leo Giakoumakis, "Rule profiling for query optimizers and their implications", 2013 IEEE 29th International Conference on Data Engineering (ICDE), vol. 00, no. , pp. 1072-1080, 2010, doi:10.1109/ICDE.2010.5447870
81 ms
(Ver 3.1 (10032016))