Study on the Optimization Method of Select Query Sentence in Standard SQL Language | Zendy

Yuqing Geng | Zendy; Chunsheng Zhang | Zendy

AI Assistant Blog Pricing

Home ZAIA Blog

Open Access

Study on the Optimization Method of Select Query Sentence in Standard SQL Language

Author(s) -

Yuqing Geng,

Chunsheng Zhang

Publication year - 2009

Publication title -

computer and information science

Language(s) - English

Resource type - Journals

eISSN - 1913-8997

pISSN - 1913-8989

DOI - 10.5539/cis.v2n1p121

Subject(s) - computer science , sentence , sql , query optimization , standard language , query by example , programming language , natural language processing , information retrieval , web search query , linguistics , search engine , philosophy

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.

The content you want is available to Zendy users.

Already have an account? Click here to sign in.

Having issues? You can contact us here

Accelerating Research