Locking escalation to page-level or table-level locking.
从页面级锁升级到表级锁。
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.
在这个语法示例中,必须定义一个新列或者定义一个表级约束。
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能够更好地满足您的需求。
Table-level predicates typically exist on some dimension tables as well.
表级谓词通常也存在于一些维度表中。
Figure 11 shows the Health Center's Profiling perspective. It includes a table of the most active methods, sorted by activity level (hotness), and a set of recommendations.
图11显示HealthCenter的Profiling透视图,它包含一个按照活跃程度(热度)排序的最活跃方法表和一组建议。
In theory, there is only a certain level of loose coupling that SQL and RDBMS can cope with before table structure reorganization must occur.
在理论上,在必须执行表结构重组之前,SQL和RDBMS只能处理某种程度的松散耦合。
We can alter the matrix's "grain" or level of detail so that each row represents a single fact table (or cube) related to a business process.
我们可以改变矩阵的“粒度”或细节水平,使得每一行代表与一个业务流程相关的单个事实表(或立方体)。
After the table is redistributed (the table goes back to the normal state), you are required to take a tablespace level backup in order to acquire full access to the table again.
在这个表被重分发之后(回到正常状态),需要进行一个表空间级的备份,以便重新获得对该表的全部访问权。
At the retail level, that means that the brisket on the Passover table costs 17 percent more this year than it did last.
而就零售价而言,那意味着餐桌上的牛腩价格较去年上涨了17%。
A table space can comprise one or more containers, which can be a file or directory at the operating system level.
表空间可以由一个或多个容器组成,这些容器可是操作系统的一个文件或一个目录。
Figure 1 shows how table level statistics are generated on a fragmented table.
图1显示了如何对片段表生成表级别的统计数据。
The level of a dimension table corresponds to number of links it needs to connect to the central fact table.
维度表的层次与它需要连接到中心事实表的连接数目有关。
There is however one level of association: each table space will be assigned to one process that is solely responsible for processing all the data in that table space.
然而数据页之间还是有一定的关联:每个表空间将被指定给一个单独负责处理该表空间中所有数据的进程。
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.
执行这个函数模块的用户需要有在逻辑表级访问数据的权限。
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?
对于数据库,表空间级备份是否就够了,还是需要完整的数据库备份?
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.
对于联机备份,有两种可以采用的备份级别:表空间级和数据库级联机备份。
Using this feature, data stewards can control read and write access for users and groups at the table column and row level.
借助这个特性,数据管理员可以在表的列和行级别控制用户和组的读写访问。
Now we can drag the top Work Items data set to the report, and the top level table is created automatically.
现在我们可以将TopWorkItems数据集拖拉到报表之中,而顶级层次的表格将会得到自动创建。
To do an online table space and database level backup using the Control Center, follow these steps.
要使用ControlCenter来执行联机表空间级和数据库级备份,请执行这些步骤。
You can, however, always roll up (summarize) the data to create a table with a less detailed level of granularity.
但是,您总是可以上卷(汇总)数据以创建一个略粗的粒度级别的表。
With Query Annotation, you can format the SQL statement for improved readability and navigation and see which statistics are being used at the table and column level.
可以使用QueryAnnotation控制sql语句的格式以提高可读性,还可以查看表级和列级使用的统计数据。
With Query Annotation, you can format the SQL statement for improved readability and navigation and see which statistics are being used at the table and column level.
可以使用QueryAnnotation控制sql语句的格式以提高可读性,还可以查看表级和列级使用的统计数据。
应用推荐