Consider a banking application where there is a very large account table for one of the dimensions.
考虑一个银行应用程序,其中针对一个维度有一个极其大型的帐户表。
Consider whether having the tables in table Spaces with different Settings is likely to significantly increase performance.
考虑如果让表空间中的表具有不同的设置,是否有可能显著提高性能。
For example, if the base table is DPF partitioned, the design of the MQT should consider whether to replicate the MQT across the data partitions.
例如,如果基本表使用了DPF进行分区,那么MQT的设计就应该考虑是否要在各个数据库分区上复制MQT。
Consider buffer pool utilization, which might lead you to make some changes to the previous table space design.
考虑缓冲池的利用率。这可能会使前面的表空间设计产生一些变化。
But if we only consider the builds that were expected to pass, we actually have an 80% pass rate (see Table 1).
但是如果我们只考虑我们期望通过的构建,那么我们实际拥有80%的通过率(参见表1)。
Additivity becomes important when you consider the possible summarizations that will occur on a fact table.
当您考虑将在事实表上发生的可能汇总时,相加性就变得很重要。
As a first example, consider a database schema consisting of a single table for a phone book application as shown in table 1.
看第一个简单的例子,考虑一个电话簿应用程序的由单个表组成的数据库模式,如表1所示。
When you have multiple user table Spaces and multiple devices, consider the application logic to distribute the workload as evenly as possible among these devices.
当有多个用户表空间和多个设备时,应当考虑应用程序逻辑,以尽可能平均地在这些设备上分配工作负载。
If a table is used heavily and is frequently updated, then you should consider periodically running the defragmenter on it.
如果表的使用非常频繁,并经常更新,那么可以考虑在该表上定期进行碎片整理操作。
If you are working with large data sets, consider using a dedicated buffer pool for the table space.
如果是使用大型数据集,可考虑用专用的缓冲池来代替表空间。
Consider using a table variable instead a temporary table.
考虑使用表变量来代替临时表。
We consider materialized query table (MQT) support an important option to further fine tune the performance of your federated server.
我们考虑物化查询表(MQT)支持一个重要的选项来进一步优化联邦服务器的性能。
Consider the table address, which contains addresses from my customers.
考虑表address,其中包含顾客的地址。
If the table is a range clustered table (that does not support row compression), you can consider switching it to become a range partitioned table (that supports row compression).
如果表是一个范围集群表(不支持行压缩),可以考虑将其变换为范围分区表(支持行压缩)。
Where activity against a table is read-only, consider creating a read-only view of the table.
在表的活动是只读的地方,请考虑创建表的只读视图。
Consider all tables for automatic table reorganization that are smaller than 52kb, perform all index reorganizations online, and use a system temporary table space when doing reorganization.
考虑对所有小于52kb的表进行自动表重组,在线执行所有索引重组,并在重组时使用系统临时表空间。
Where a message flow only reads data from a table, consider using a read only view of that table.
当消息流仅从表读取数据时,请考虑使用表的只读视图。
Now consider the different encodings for this character from Table 1, and you can see that the hexadecimal representation of different encodings and their length in different code units are diffrent.
考虑表1中对此字符的不同编码,您会发现不同代码单元中的不同编码的十六进制表示及其长度都有所不同。
You can specify for example what REOPT options to use, or what MQT table to consider or what query optimization to use.
例如,可以指定使用哪个REOPT选项,使用哪个mqt表,或者使用什么样的查询优化。
Table 1 is a checklist example that a developer should consider when testing a service that will be covered by a SLA
表1是一个核对表示例,当开发者测试一个将被 SLA 保证的服务时,他应该考虑这个表。
Consider the following query on the EMPLOYEE table in the SAMPLE database.
考虑对SAMPLE数据库的employee表执行如下查询。
Consider a simple database table, called DVDs.
考虑一个名为DVDs的简单数据库表。
Let's consider the following table and data.
让我们来考虑下面的表和数据。
Problems arise when the location where a temporary table is declared differs from where it may be used. Consider the following.
当声明临时表的位置与使用它的位置不同时,会引起问题。
Before attempting an alter operation against a replication table, consider the following.
在尝试对一个复制表执行alter操作时,考虑以下方面。
Now consider the following query, which USES the alias' SEC 'for the table name.
现在考虑下面的查询,将对表名使用“sec”作为别名。
The main difference between the reference model and the basic topic or concept model is that everything in a reference must go into a section or table. Consider these possibilities.
参考模型与基本主题或概念模型的主要区别在于:参考中的所有内容都必须放在节或者表中。
Here are some things to consider when trying to decide whether or not to compress a table space or partition.
在决定是否压缩一个表空间或分区时,要考虑下面一些事情。
As an example to illustrate one of these functions, consider the array concat function with respect to Table 3.
作为一个例子,考虑表3中的arrayconcat函数。
Now, let us consider an inventory table consisting of three columns - item_num, customer_name and amount.
现在,我们来考虑一个inventory表,这个表由三个列组成—item_num、customer_name和amount。
应用推荐