By internal statistics , i mean the statistics in the system catalogs that the optimizer uses to determine the lowest - cost query execution plan 通过内部统计数据,我指的是系统目录中的统计数据,优化器可以确定最低成本的查询执行计划。
The core of the sql server 2005 system catalogs is a set of views that show metadata that describes the objects in an instance of sql server Sql server 2005系统目录的核心是一个视图集,这些视图显示了描述sql server实例中的对象的元数据。
Although these stored procedures and functions are specific to sql server , they insulate users from the structure of the underlying system catalog tables 虽然这些存储过程和函数为sql server所特有,但它们使用户与基础系统目录表的结构隔离开了。
To find out all accounts with privileges , you can query each of the system catalog views and combine the results together using the union operator , as shown in 要查明具有特权的所有帐号,可以查询每个系统编目视图并使用union操作符将结果组合在一起,如
Update statistics high against the database . this command updates the statistics in the system catalogs that the optimizer uses to determine the lowest - cost query plan 此命令更新了系统目录中的统计数据,优化程序使用这些数据来确定成本最低的查询计划。
system catalogとは意味:システム?カタログ system catalog meaning:[Computer] < database > The data dictionary of a DBMS . The system catalogue stores meta-data including the schemas of the databases . It is a mini-database, and is usually stored us...system catalog перевод:системный каталог