一个经常存取的表，一定要把它的数据和索引分布在不同的磁盘上吗？

转载于 2008-07-18 09:47:35 发布 · 115 阅读

文章标签：

本文探讨了一种常见的I/O分布优化误解，即频繁使用的表与其索引分离存储的方法并不总是有效。在事务处理过程中，索引与表数据的读取通常是顺序进行的，因此将它们放在同一磁盘上可以避免争用问题，提升数据库性能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

One popular approach to manual I/O distribution suggests separating a frequently used table from its index. This is not correct. During the course of a transaction, the index is read first, and then the table is read. Because these I/Os occur sequentially, the table and index can be stored on the same disk without contention. It is not sufficient to separate a datafile simply because the datafile contains indexes or table data. The decision to segregate a file should be made only when the I/O rate for that file affects database performance.

-- 引用自 <>

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/136097/viewspace-1007462/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/136097/viewspace-1007462/