Query Method and Optimization Techniques Based on Relational Database
Zahng Zhi-qing · Coal Technology · 2012
The meaning and advantages from the aspect of the relational database language SQL overview,discusses the SQL-based relational database query method,proposed SQL-based relational database optimization techniques: update statistics to optimize the system design,rational use of the system index,to avoid or simplify the sorting,the use of stored procedures,database crash recovery techniques to improve and optimize the operating environment.