SQL Query Optimization Methods of Relational Database System

被引：6
|
作者：
Li, Dandan [1 ]
Han, Lu [1 ]
Ding, Yi [1 ]
机构：
[1] Beijing City Univ, Dept Comp Software, Beijing, Peoples R China
来源：
2010 SECOND INTERNATIONAL CONFERENCE ON COMPUTER ENGINEERING AND APPLICATIONS: ICCEA 2010, PROCEEDINGS, VOL 1 | 2010年
关键词：
Query optimization; SQL Server; Relational database;
D O I：
10.1109/ICCEA.2010.113
中图分类号：
TP39 [计算机的应用];
学科分类号：
081203 ; 0835 ;
摘要：
Oracle provides several options to aid performance, such as partitioning large tables, using materialized views, storing plan outlines, and many others. This chapter examines how DBAs can use these techniques to aid developers' efforts to increase the efficiency of their application code. This chapter introduces the SQL Tuning Advisor to help you tune SQL statements. You can then use the recommendations of this advisor to rewrite poorly performing SQL code. I begin the chapter with a discussion of how to approach performance tuning. More than the specific performance improvement techniques you use, your approach to performance tuning determines your success in tuning a recalcitrant application system.
引用
收藏
页码：557 / 560
页数：4
相关论文
共 50 条
  • [21] XML data storage and query optimization in relational database by XPath processing model
    Zhang, H. (zhanghaiwei@dbis.nankai.edu.cn), 1600, Academy Publisher (08):
  • [22] Query Execution Optimization in Spark SQL
    Ji, Xuechun
    Zhao, Maoxian
    Zhai, Mingyu
    Wu, Qingxi
    SCIENTIFIC PROGRAMMING, 2020, 2020 (2020)
  • [23] A Novel Approach for SQL Query Optimization
    Mithani, Fazal
    Machchhar, Sahista
    Jasdanwala, Fernaz
    2016 IEEE INTERNATIONAL CONFERENCE ON COMPUTATIONAL INTELLIGENCE AND COMPUTING RESEARCH, 2016, : 898 - 901
  • [24] QUERY OPTIMIZATION IN MICROSOFT SQL SERVER
    Haxhijaha, Blerta
    Ajdari, Jaumin
    Raufi, Bujar
    Zenuni, Xhemal
    Ismaili, Florie
    INTERNATIONAL JOURNAL ON INFORMATION TECHNOLOGIES AND SECURITY, 2018, 10 (02): : 13 - 22
  • [25] A RELATIONAL QUERY LANGUAGE INTERFACE TO A HIERARCHICAL DATABASE-MANAGEMENT SYSTEM
    CHUNG, CW
    MCCLOSKEY, KE
    SECOND INTERNATIONAL CONFERENCE ON DATA AND KNOWLEDGE SYSTEMS FOR MANUFACTURING AND ENGINEERING, 1989, : 105 - 112
  • [26] A JIT Compilation-based Unified SQL Query Optimization System
    Lee, Myungcheol
    Lee, Miyoung
    Kim, ChangSoo
    2016 6TH INTERNATIONAL CONFERENCE ON IT CONVERGENCE AND SECURITY (ICITCS 2016), 2016, : 193 - 194
  • [27] Query Optimization by Attributes Annotation in a Database Mediation System
    Bakhtouchi, Abdelghani
    Bellatreche, Ladjel
    Balla, Amar
    Mataoui, M'hamed
    2009 SECOND INTERNATIONAL CONFERENCE ON THE APPLICATIONS OF DIGITAL INFORMATION AND WEB TECHNOLOGIES (ICADIWT 2009), 2009, : 20 - 25
  • [28] Distributed Database System Query Optimization Algorithm Research
    Fan Yuanyuan
    Mi Xifeng
    PROCEEDINGS OF 2010 3RD IEEE INTERNATIONAL CONFERENCE ON COMPUTER SCIENCE AND INFORMATION TECHNOLOGY (ICCSIT 2010), VOL 8, 2010, : 657 - 660
  • [29] I-Rex: An Interactive Relational Query Explainer for SQL
    Miao, Zhengjie
    Chen, Tiangang
    Bendeck, Alexander
    Day, Kevin
    Roy, Sudeepa
    Yang, Jun
    PROCEEDINGS OF THE VLDB ENDOWMENT, 2020, 13 (12): : 2997 - 3000
  • [30] Using a deductive database for modular SQL query development
    Maskarinec, M
    Neumann, K
    IC-AI'2001: PROCEEDINGS OF THE INTERNATIONAL CONFERENCE ON ARTIFICIAL INTELLIGENCE, VOLS I-III, 2001, : 453 - 456
12345