一种基于字段使用频率的索引选择模型及算法实现

摘要

本文基于SQL Server 2000数据库，通过对索引开销的研究，针对如何建立最适当索引的问题给出索引选择模型以及相应算法，并比较各算法的优劣，确定最优选择%Based on SQL Server 2000,focus on how to create the most proper indexes,and gives the index selection model and the corresponding algorithm through the research of index spending.Then compare the pros and cons of each algorithm to determine the optimal choice.