Automatic SQL Tuning in Oracle 10g

Proceedings 2004 VLDB Conference: The 30th International Conference on Very Large Databases (VLDB)

Volumn , Issue , 2004, Pages 1098-1109

  Dageville, Benoit ^a   Das, Dinesh ^a   Dias, Karl ^a   Yagoub, Khaled ^a   Zait, Mohamed ^a   Ziauddin, Mohamed ^a  

^a ORACLE CORPORATION   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

EID: 85016161371     PISSN: None     EISSN: None     Source Type: Book    
DOI: 10.1016/B978-012088469-8.50096-6     Document Type: Chapter

References (11)

1. M. Stillger Michael, G.M. Lohman Guy M. and V. Markl Volker (2001) Mokhtar Kandil: LEO-DB2's Learning Optimizer. The VLDB Journal
2. V. Markl, G.M. Lohman and V. Raman (2003) LEO: An autonomic query optimizer for DB2. IBM Systems Journal Vol. 42(No 1)
3. Q. Software Quest and Quest Central for Oracle: SQLab Vision (2003) http://www.quest.com
4. Leccotech (2003) LECCOTECH Performance Optimization Solutions for Oracle. White Paper http://www.leccotech.com/
5. S. Chaudhuri and V. Narasayya (1997) An Efficient, Cost-driven Index Tuning Wizard for Microsoft SQL Server. 23rd International Conference on Very Large Data Bases
6. Oracle Corporation (2003) Performance Tuning using the SQL Access Advisor. Oracle White Paper http://otn.oracle.com
7. Oracle Corporation (2003) Database 10g: The Self-Managing Database. Oracle White Paper http://otn.oracle.com
8. Oracle Corporation (2003) The Self-Managing Database: Automatic Performance Diagnosis. Oracle White Paper http://otn.oracle.com
9. Oracle Corporation (2003) The Self-Managing Database: Guided Application and SQL Tuning. Oracle White Paper http://otn.oracle.com
10. G. Valentin Gary, M. Zuliani Michael, D. Zilio Daniel and G. Lohman Guy (2000) Alan Skelley: DB2 Advisor: An Optimizer Smart Enough to Recommend Its Own Indexes. 16th International Conference on Data Engineering
11. H. Pirahesh Hamid, J. Hellerstein Joseph and W. Hasan Waqar (1992) Extensible/Rule Based Query Rewrite Optimization in Starburst. ACM SIGMOD Conference