Study on improving the query speed of massive database
Xu Bin · Journal of Zhengzhou University of Light Industry · 2008
Aiming at the problem of slow querying and instability of using usual database design and taking a database of the students in high schools of a province as the research object,a design thought of dividing the field of student number into two fields and building unite clustered index was proposed.The testing results show that this approach can improve the query speed up to 4 times and have better stability than usual.