Research on the Performance Optimization of Massive Data Query Based on the Index

The explosive growth in data quantity today, massive data query performance is good or bad becomes important. In order to avoid system response time is long, wasted resources from happening. We are actively exploring methods and strategies to make massive data query performance optimization. Massive data query performance optimization is a systematic project, involving many aspects, in which the index plays an important role. This article obtains from the index, based on Oracle, the paper analyzes the structure of B-tree index, the way of data scanning, as well as how to correctly use the index and rely on the index attribute to optimize massive data query performance.