For example , a select using the nolock hint does not acquire share locks when reading data , but might sometime request locks when reading a system catalog view 例如,使用nolock提示的select在读取数据时不获取共享锁,但有时在读取系统目录视图时可能会请求锁。
The db2 optimizer renders expert opinions on data retrieval methods based on the situational data housed in db2 s system catalog and a query input in sql format Db2优化器会根据存储在db2系统目录中的情境数据和sql格式的查询输入来生成对数据检索方法的专家意见。
For example , if a fillfactor setting is not specified in the rebuild clause , the fill factor value stored in the system catalog will be used during the rebuild process 例如,如果未在rebuild子句中指定fillfactor设置,将在重新生成过程中使用系统目录中存储的填充因子值。
Instance level authority levels sysadm , sysctrl , sysmaint , and sysmon and group membership are defined outside of db2 udb , and are therefore not reflected in system catalog tables 实例级权限级别( sysadm 、 sysctrl 、 sysmaint和sysmon )和组成员关系是在db2 udb之外定义的,因此不会反映在系统编目表中。
The db2 optimizer then queries system information and statistics stored in the db2 system catalog to determine the best method of accomplishing the tasks necessary to satisfy the sql request Db2优化器然后查询存储在db2系统目录中的系统信息和统计信息,以确定完成满足sql请求所必需的任务的最佳方法。
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 перевод:системный каталог