If the table in your query are pretty small (usually fewer than 1,000 rows) or clustered tables, and your query is not selective at all, it would be beneficial to use a table scan.
如果查询中的表极其小(通常少于1,000行)或者是群集表,而且查询根本没有选择性的话,那么使用表扫描会更好一些。
This is usually the second worst performing strategy due to its cache lock requirement and the heavy "push" update policy for clustered caches.
这通常是性能倒数第二的策略,因为它要求有缓存锁,缓存集群中使用重量级的“推”更新策略。
Logging in a clustered environment, however, requires more planning because messages are generated from different sources (usually different machines).
然而,集群环境中的日志需要更多规划,因为消息都是从不同的源头生成的(通常是不同的机器)。
应用推荐