比方说,程 序有两种方法可以选择,一是表格扫描(table-scanning)、一是逻辑判断 (logic-driven),前者比较慢,但也比较安全,既然安全比速度优先考虑, 那么除非有别的重要理由,您应该选择表...
基于1个网页-相关网页
When scanning an MDC table, block locking could be deferred for an index scan.
当扫描一个mdc表时,对于索引扫描,块锁可以推迟。
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.
从性能的角度来看,这被认为是一个非常有效的联接操作,因为通过贯穿唯一索引的唯一访问扫描内部表的成本是最优的。
Alternatively, you can have a table striped across multiple drives to allow faster scanning than with the same table stored on a drive.
另外,您还可以选择将一个表拆开,放到多个驱动器上,这样比将同一个表存储在一个驱动器上扫描起来快。
应用推荐