Optimization of inquiry statements in structured query language based on relational database
Zhang Ke-meng · Guangdong Electric Power · 2005
To improve the operation efficiency of database,factors influencing the execution efficiency of inquiry statements in structured query language (SQL)are analyzed.On this basis,optimization of SQL inquiry statements is studied in terms of data types,search parameters and math operational characters.Meanwhile,it is indicated that programmers should repetitively test and compare various statements in practice so as to achieve the best scheme.