Locking escalation to page-level or table-level locking.
从页面级锁升级到表级锁。
Table-level predicates typically exist on some dimension tables as well.
表级谓词通常也存在于一些维度表中。
Constraints come in two types: table-level constraints and column constraints.
约束有两种类型:表级约束和列约束。
This implies that the table must have one or more columns or table-level constraints.
这意味着表必须有一个或多个列级或表级约束。
In this syntax example, you must either define a new column or define a new table-level constraint.
在这个语法示例中,必须定义一个新列或者定义一个表级约束。
It USES auto_increment primary key, which causes table-level locks in InnoDB for all MySQL versions prior to 5.1.21.
使用了auto_increment主键,对于MySQL5.1.21之前的版本都会导致in noDB使用表级锁。
For example, SYSIBM.SYSCOLAUTH, which details column-level privileges, is a child of SYSIBM.SYSTABAUTH, which records table-level privileges.
例如,SYSIBM . SYSCOLAUTH包含列级权限的详细信息,它是SYSIBM .SYSTABAUTH的子表,后者记录了表级权限。
If the remote view contains a complex query, using table-level statistics such as the cardinality for the nickname over the view can be misleading.
如果远程视图包含一个复杂的查询,那么使用表级统计信息(例如视图昵称的基数)可能使人产生误解。
Some databases (such as SQL Server) allow you to disable the page-level locking in hopes that it won't escalate from a row-level lock to a table-level lock.
一些数据库(比如sqlServer)允许您禁用页面级锁,以期它不会从行级锁切换到表级锁。
There are little tricks one can do to increase concurrency, but if your applications need table-level or row-level locks, a DBMS will better suit your needs.
虽然有一些增加并发的技巧,但是,如果应用程序需要的是表级别或行级别的锁定,那么DBMS能够更好地满足您的需求。
Includes a high-availability data replication (HDR) feature for disaster recovery and continuous log restore, point-time instance-wide restore, and table-level backup and recovery.
内含高可用性资料抄写 (HDR)功能,以便提供灾难回复与连续记录还原、时间点实例层面还原、表格层次备份及回复。
Using this feature, data stewards can control read and write access for users and groups at the table column and row level.
借助这个特性,数据管理员可以在表的列和行级别控制用户和组的读写访问。
Figure 1 shows how table level statistics are generated on a fragmented table.
图1显示了如何对片段表生成表级别的统计数据。
To do an online table space and database level backup via CLP command prompt, follow the steps below.
要通过CLP命令行提示执行联机表空间级和数据库级备份,请执行下面这些步骤。
For online backups, there are two levels of backups that can be taken, table space and database level online backup.
对于联机备份,有两种可以采用的备份级别:表空间级和数据库级联机备份。
For ATTACH operation: fragmented statistics of the new fragment is built, and table level statistics is rebuilt from all fragmented statistics.
对于ATTACH操作:将对新的片段构建片段统计,并利用所有的片段统计重新构建表级统计。
For the database, are table space level backups sufficient, or are full database backups necessary?
对于数据库,表空间级备份是否就够了,还是需要完整的数据库备份?
For DETACH operation: table level statistics of the resulting tables are rebuilt from the fragmented statistics.
对于DETACH操作:生成的表的表级统计是使用片段统计重新构建的。
The user executing the function module needs to have the appropriate rights to access data at the logical table level.
执行这个函数模块的用户需要有在逻辑表级访问数据的权限。
You can use the table property STATCHANGE if you wish to control the change threshold at the table level instead of system level.
如果希望在表级别而不是在系统级别控制修改阈值,可以使用表属性STATCHANGE。
Myisampack.exe Compresses myisam table use VALUE COMPRESSION in create table statement to use the space saving row format at the column or table level to reduce space required for a table.
exe压缩myisam表在创建表的语句中使用VALUECOMPRESSION,可以在列或表级别上使用节省空间的行格式来减少空间占用。
Notice that data from all fragments is sorted together to form table level statistics, which is encoded and stored in the system catalog sysdistrib.
注意,来自所有片段的数据被一同存储,形成了表级别的统计数据,被编码并存储到系统目录sysdistrib中。
Finally table level statistics is formed by merging all constituent fragments statistics and stored in sysdistrib.
最终,将所有这些片段统计合并起来就构成了表级统计数据,并存储到sysdistrib。
Besides database backups, you can take a table space level backup in the case of DB2, and a dbspace backup in the case of IDS.
除了对数据库备份外,在db 2中还可进行表空间级的备份,在IDS中可以进行dbspace备份。
The first thing every contestant needed to do was change every table to row-level locking.
每位参赛者需要做的第一件事是将每个表更改为行级别锁定。
As the name suggests, the step table contains low-level test steps that specify the actions that the automated test takes in application under test.
作为其名字所暗示的那样,步骤表格包含了低层次的测试步骤,该步骤指定了测试中程序所采取的自动化测试操作。
The table space placement for XML data is determined by the LONG in clause, which can be specified at partition level, table level, or any combination thereof.
XML数据的表空间位置由LONGin子句决定,其可在分区级别、表级别、或它们的任何组合中指定。
If the table has fragment-level statistics, the decision to refresh statistics is done at the fragment level, thereby rebuilding statistics only for changed or new fragments.
如果表具有片段级统计,那么将在片段的层面上判断是否执行统计刷新,因此只有片段被修改或出现新片段的情况下重建统计。
The granularity of the content type is to the table level rather than the row level.
内容类型的粒度是表级别的而不是行级别的。
The parallel table option tells the redistribute utility to perform parallelism at the table level where multiple tables are redistributed at the same time.
PARALLELTABLE选项告诉重分发实用程序,在表级并行执行重分发,并同时重分发其中的多个表。
应用推荐