%0 Journal Article
%T Design and Implementation of Query Statistic Optimization Method Based on Physical Cluster and Splitting Table<br>一种基于聚簇和分表技术的查询统计优化方法的设计与实现
%A QI Xian-hong
%A LI Ai-ping
%A JIA Yan
%A XU Zhi-ying
%A DU Juan
%A <br>齐贤红
%A 李爱平
%A 贾焰
%A 徐志英
%A 杜娟
%J 计算机应用研究
%D 2006
%I 
%X 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.
%K Query Optimization
%K Physical Cluster
%K Split Large Table<br>查询优化
%K 物理聚簇
%K 分裂大表
%U http://www.alljournals.cn/get_abstract_url.aspx?pcid=5B3AB970F71A803DEACDC0559115BFCF0A068CD97DD29835&cid=8240383F08CE46C8B05036380D75B607&jid=A9D9BE08CDC44144BE8B5685705D3AED&aid=AEA3913AE8B21FCF&yid=37904DC365DD7266&vid=EA389574707BDED3&iid=DF92D298D3FF1E6E&sid=9971A5E270697F23&eid=339D79302DF62549&journal_id=1001-3695&journal_name=计算机应用研究&referenced_num=0&reference_num=8