An efficient, cost-driven index selection tool for microsoft SQL server

Proceedings of the 23rd International Conference on Very Large Databases, VLDB 1997

Volumn , Issue , 1997, Pages 146-155

  Chaudhuri, Surajit ^a   Narasayya, Vivek ^a  

^a MICROSOFT RESEARCH   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

COSTS; DATABASE SYSTEMS; ITERATIVE METHODS; QUERY LANGUAGES; QUERY PROCESSING;

COST INFORMATION; INDEX SELECTION; INDUSTRIAL STRENGTH; ITERATIVE APPROACH; MICROSOFT SQL SERVER; NOVEL TECHNIQUES; PHYSICAL DESIGN; QUERY OPTIMIZER;

WINDOWS OPERATING SYSTEM;

EID: 84994164569     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: None     Document Type: Conference Paper

References (13)

1. Chocnni S., Blankcn H. M., Chang T., "On the Automation of Physical Database Design", Proc. of ACM-SAC, 1993.
2. Choenni S., Blanken H. M., Chang T., "Index Selection in Relational Databases", Proc. of 5 IEEE ICCI 1993.
3. Peter C, Gurry M. "ORACLE Performance Tuning", O'Reilly & Associates, Inc. 1993.
4. Chaudhuri S., Narasayya V., Physical Database Design Assistant and Wizard for SQL Server, Microsoft Research Technical report, in preparation, 1997 IFON02)
5. Frank M., Omiecinski E., Navathe S., "Adaptive and Automative Index Selection in RDBMS", Proc. of EDBT 92.
6. Finkelstein S, Schkolnick M, Tiberio P.'Thysical Database Design for Relational Databases", ACM TODS, Mar 1988.
7. Gupta H, Harinarayan V., Rajaramana A., Ullman J.D., "Index Selection for OLAP", Proc. of ICDE97.
8. Hammer M., Chan A., "Index Selection in a Self-Adaptive Data Base Management System", Proc. of SIGMOD 76.
9. Hobbs L., England K., "Rdb/VMS A Comprehensive Guide", Digital Press, 1991.
10. Ross K. A., Srivastava D., Sudarshan S. "Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time", Proc. of SIGMOD 96.
11. Harinarayan V., Rajaramana A., Ullman J.D., "Implementing Data Cubes Efficiently", Proc. of SIGMOD 96.
12. Labio W.J., Quass D., Adelberg B. "Physical Database Design for Data Warehouses", Proc. of ICDE97.
13. Rozen S., Shasha D. "A Framework for Automating Physical Database Design", Proc. of VLDB 1991.