它会基于存储在目录和统计表中的统计数据而评估每一个可能的存取计划的执行开销,然后选择最低开销的存取计划。
It estimates the execution cost of each potential access plan based on the statistics data stored in catalog and statistics tables, and selects the one with the lowest cost.
这个测试案例使用两个用户来模拟查询表申明方法中的并发存取。
This test case uses two users to simulate concurrent access in the query table claim method.
通过视图存取的数据,实际上是通过标准的T - SQL查询命令构成的,而且可以来自许多不同的基础表,甚至其他视图。
The data accessed through a view is actually constructed using standard T-SQL select command and can come from one to many different base tables or even other views.
应用推荐