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.

To make sure that you can receive messages from us, please add the 'ccsenet.org' domain to your e-mail 'safe list'. If you do not receive e-mail in your 'inbox', check your 'bulk mail' or 'junk mail' folders.