Power hints for query optimization

Proceedings - International Conference on Data Engineering

Volumn , Issue , 2009, Pages 469-480

  Bruno, Nicolas ^a   Chaudhuri, Surajit ^a   Ramamurthy, Ravi ^a  

^a MICROSOFT RESEARCH   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

COMMERCIAL DATABASE SYSTEM; NON-TRIVIAL; OPTIMIZER; OPTIMIZERS; QUERY OPTIMIZATION;

DATABASE SYSTEMS;

EID: 67649643451     PISSN: 10844627     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1109/ICDE.2009.68     Document Type: Conference Paper

References (15)

1. S. Christodoulakis, "Implications of certain assumptions in database performance evauation," ACM TODS, vol. 9, no. 2, 1984.
2. B. A. Patel, "Forcing query plans," 2005. [Online]. Available: http://www.microsoft.com/technet/prodtechnol/-sql/2005/frcqupln.mspx
3. G. Graefe, "The Cascades framework for query optimization," Data Engineering Bulletin, vol. 18, no. 3, 1995.
4. P. G. Selinger, M. M. Astrahan, D. D. Chamberlin, R. A. Lorie, and T. G. Price, "Access path selection in a relational database management system," in Proceedings of the ACM International Conference on Management of Data (SIGMOD), 1979.
5. R. Bellman, Dynamic Programming. Princeton University Press, 2003.
6. M. F. Fernandez, A. Malhotra, J. Marsh, M. Nagy, and N. Walsh, "XQuery 1.0 and XPath 2.0 Data Model (XDM)," 2007. [Online]. Available: http://www.w3.org/TR/2007/REC-xpath-datamodel-20070123
7. I. Chan, "Oracle(R) Database Performance Tuning Guide 10g Release 2 (10.2)," 2008. [Online]. Available: http://download.oracle.com/docs/cd/ B19306 01-/server.102/b14211/hintsref.htm
8. T. Neumann and G. Moerkotte, "An efficient framework for order optimization," in Proceedings of the International Conference on Data Engineering (ICDE), 2004.
9. S. Borzsonyi, D. Kossmann, and K. Stocker, "The skyline operator," in Proceedings of the International Conference on Data Engineering (ICDE), 2001.
10. K. Billings, "A TPC-D Model for Database Query Optimization in Cascades. Ms. thesis, Portland State University," 1996.
11. N. Bruno and R. Nehme, "Configuration-parametric query optimization for physical design tuning," in Proceedings of the ACM International Conference on Management of Data (SIGMOD), 2008.
12. TPC Benchmark H, "Decision support." [Online]. Available: http://www.tpc.org
13. SQLServer Books Online, "Query hint (transact-sql)," 2007. [Online]. Available: http://technet.microsoft.com/en-us/library/-ms181714.aspx
14. "Giving optimization hints to DB2," 2003. [Online]. Available: http://publib.boulder.ibm.com/infocenter/-dzichelp/v2r2/index.jsp?topic=/com. ibm.db2.doc.admin/-p9li375.htm
15. "Optimizer profiles and guidelines overview," 2008. [Online]. Available: http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/ com.ibm.db2.udb.admin.doc/doc/c0024522.htm