Design and Implementation of Query Statistic Optimization Method Based on Physical Cluster and Splitting Table
一种基于聚簇和分表技术的查询统计优化方法的设计与实现

Based on the characteristic of query statistic, introduces an optimization method which enable related records clustered in the block when system organize files,split large table into some small tables when the large table have a number of data and create index on the small tables.This not only reduces the times of disk I/O, but also cut down scan times.This method can improve query statistic efficiency and has been used to create some projects successful.