文章基本信息

标题：Study on the Optimization Method of Select Query Sentence in Standard SQL Language
本地全文：下载
作者：Yuqing Geng ; Chunsheng Zhang
期刊名称：Computer and Information Science
印刷版ISSN：1913-8989
电子版ISSN：1913-8997
出版年度：2009
卷号：2
期号：1
页码：121
DOI：10.5539/cis.v2n1P121
出版社：Canadian Center of Science and Education
摘要：Normal 0 7.8 ? 0 2 false false false MicrosoftInternetExplorer4  /* Style Definitions */ table.MsoNormalTable {mso-style-name:????; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} In the actual information management system, the query operation is the main part, and the query method is completed by the Select sentence in SQL language, so the efficiency of Select sentence directly influences the query efficiency, and the factors influencing query efficiency include query condition, view, index, link, operator and memory process. In the article, combining with examples, we analyzed the influences of various factors on the query speed and summarized the strategy which used these five factors to optimize Select query sentence, and the concrete example indicated that these optimization process are simple, convenient and effective, and they could enhance the response speed of query.