The methods of SQL sentences'optimization on index
Liu Xiaoping · Journal of Shaoguan University · 2006
Enquiry is the most basic and frequently used operation in the database,and query optimization have become one of the most important meanses on the performance of database.The index principle and index type are introduced by index technique.The principia of upbuilding index is put forward.Through example, the way of optimization in sql sentences is discussed and for all of this can improve the system performance.