基于关系数据库的查询优化技术

The Technology of Query Optimization Based on the Relational Database

为了提高数据库的运行效率,分析了影响结构化查询语言(SQL)查询语句执行效率的因素,研究了对SQL查询语句进行优化的基本方法,包括数据类型、搜索参数、数学操作符等方面的合理使用,同时,指出在实践中的程序员应反复试验和比较不同的语句。

For promoting the running efficiency of the database, the paper has analyzed the elements of influencing the efficiency of SQL querying the language, studied the basic method of optimizing the SQL queries the language, including data type, searching parameter, mathematical operand and so on. Meanwhile, the paper has also pointed out that programmer should experiment and compare different language again and again in practical.