外键列索引的效率分析

Efficiency Analysis of Indexes of Foreign Key Columns

索引是与表或视图关联的磁盘上结构,可以加快从表或视图中检索行的速度。高效的索引对于获得良好的数据库和应用程序性能极为重要。参照完整性是关系数据库管理系统必须满足的完整性约束条件,可以维护主外键数据的一致性。通过实验分析验证在外键字段上建立索引的必要性。

Index as a diskette structure, can improve efficiency of scaning on tables or views. The efficient indexes are very important for obtaining good performance on databases and applications. As one of the constrain condition rules of relational database, referential integrity can maintain the uniformity of primary key and foreign key data. Illustrates the necessity of building indexes on foreign key columns through experimental analysis.