SQL Tuning Research About Short Message System's Database

The database optimization is an important branch of the platform system optimization, which is a concern of many researchers around the world in recent years. The major purpose of the database optimization is to find out problems of database programming and applied designs, via analyzing the functions and situations of the database. Then the focus is to resolve the problems, to improve the performance of the database and optimize its working capability.This paper is engaged in the research of analyzing the bottleneck problems related to database of the text message system. Therefore, it works out the corresponding optimizing measures, which turns out to be quite effective. The paper also explains the principles of one critical process of the database optimization ----applied performance optimization of SQL. In addition, the paper deals with how to get the performing plan with AUTOTRACE and pick out the best performing plan by using OPTIMIZER, and so on and so forth. The paper takes a typical case of text message system database optimization for example and talks about the process of SQL optimization at length as well as how it helps improve the performance of the database.