This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
2010 IEEE 26th International Conference on Data Engineering (ICDE 2010)
Rule profiling for query optimizers and their implications
Long Beach, CA, USA
March 01-March 06
ISBN: 978-1-4244-5445-7
Surajit Chaudhuri, Microsoft Corp, One Microsoft Way Redmond WA, USA
Leo Giakoumakis, Microsoft Corp, One Microsoft Way Redmond WA, USA
Vivek Narasayya, Microsoft Corp, One Microsoft Way Redmond WA, USA
Ravishankar Ramamurthy, Microsoft Corp, One Microsoft Way Redmond WA, USA
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.
Citation:
Surajit Chaudhuri, Leo Giakoumakis, Vivek Narasayya, Ravishankar Ramamurthy, "Rule profiling for query optimizers and their implications," icde, pp.1072-1080, 2010 IEEE 26th International Conference on Data Engineering (ICDE 2010), 2010
Usage of this product signifies your acceptance of the Terms of Use.