Query Optimization Research on Mass of Data Based on Oracle Database
Sun Wei-hua · Computer Technology and Development · 2012
While database has large amount of data,the inquires will have a series of problems like system response time is too long and take up too many system resources.So the query optimization research on the mass of data based on Oracle database is necessary.It uses the various measures and methods to improve the response speed based on Oracle database such as reasonably designing the database structure,the use of the index,partition,SQL optimization method.In addition,pagination display the query results can also greatly improve query speed.Experiments show the optimization obviously improves the speed a lot.