Performance Analysis of Student Card System Based on Optimization of SQL
Wei Ran · Journal of Huaiyin Institute of Technology · 2012
In order to improve the performance of query and analysis of the student card system,the original SQL query in system needs to be further optimized.Indexing for different field is an effective way of optimization.In this way,student ID need to use the aggregate index,temporary table and union inquiry will be used in this experiment for examination.Finally,this experiment analyzes the time of different types of queries.Experimental results show that indexing system can improve the performance of the student card system,and if Aggregate index in Keyword is used,the performance will have a greater improvement.This experiment can provide a good reference value for other application of similar systems.