Statements involving larger tables and joins of two or more tables are more likely to exhibit a change in query access plan as a result of the improved cardinality estimate.
如果语句涉及到更大的表格和两个或者更多个表的连接的话,查询访问计划就很可能会因为基数估计值的提高而改变。
Referential integrity is a fancy SQL term that refers to keeping all the data in your database clean, free from incorrect or unused data, and accurate in terms of joins across tables.
引用完整性是一个美妙的sql术语,它指的是保持数据库中的所有数据都是干净的,没有错误或者多余的数据,表之间的连接准确合理。
If the optimizer joins two tables first, the join results could be huge and may use a large amount of system resources such as CPU and memory.
如果优化器首先连接两个表,那么连接结果可能十分庞大,并可能使用大量系统资源,如CPU和内存。
应用推荐