比方说,程 序有两种方法可以选择,一是表格扫描(table-scanning)、一是逻辑判断 (logic-driven),前者比较慢,但也比较安全,既然安全比速度优先考虑, 那么除非有别的重要理由,您应该选择表...
基于1个网页-相关网页
From the performance perspective, this is considered a very efficient join operation, because the cost for scanning the inner table is optimal via unique access through a unique index.
从性能的角度来看,这被认为是一个非常有效的联接操作,因为通过贯穿唯一索引的唯一访问扫描内部表的成本是最优的。
We cannot pay attention to read cache hit rate since we have been sequentially scanning a huge table over and over.
由于我们一遍又一遍地顺序扫描一个巨大的表,这样我们就无法关注读缓存命中率。
Alternatively, you can have a table striped across multiple drives to allow faster scanning than with the same table stored on a drive.
另外,您还可以选择将一个表拆开,放到多个驱动器上,这样比将同一个表存储在一个驱动器上扫描起来快。
应用推荐