softmax=20(对于OLTP)
OLTP applications should not be performing large sorts.
OLTP应用程序不应该执行大型排序。
Part 2 also covers OLTP, DSS, and mixed workloads.
第2部分还将介绍OLTP、DSS以及混合的工作负载。
This means it should not be an overloaded OLTP application.
这意味着它将不是一个超载的OLTP应用程序。
Goal-oriented execution and concurrent execution with oltp.
使用OLTP的面向目标的执行和并发的执行。
This includes both OLTP and Data Warehouse applications.
这包括OLTP和数据仓库应用程序。
Quantifying the benefits of using EFDs in OLTP environments.
确定在OLTP环境中使用EFD的好处。
OLTP databases contain transacations at the most granular level.
OLTP数据库包含最细粒度级别的事务。
The database queries in TPC-H are more complex than typical OLTP queries.
TPC- H中的数据库查询要比典型的OLTP查询更加复杂。
Note: This article chiefly addresses online transaction processing [OLTP] access.
请注意:本文主要介绍在线事务处理 [OLTP]访问。
This is an online transaction processing (OLTP) system with about 500 BM of data.
这是一个在线事务处理(online transaction processing,OLTP)系统,有500MB数据。
As a rule of thumb for OLTP applications, use DMS tablespaces with multiple devices.
作为OLTP应用程序的经验法则,可在多个设备上使用dms表空间。
When used in OLTP environments, EFDs offer the following benefits over traditional HDDS.
在OLTP环境中,使用efd比传统的HDD有以下方面的优点。
In an online transaction processing (OLTP) environment, start with a value of 30 seconds.
在联机事务处理(OLTP)环境中,这个值从30秒开始。
Typically, an OLTP workload consists of many concurrently running short transactions.
通常,OLTP工作负载包括许多并发运行的短事务。
With these tips, you can get your OLTP application up and running with reasonably good performance.
有了这些技巧,就可以启动自己的OLTP应用程序并使其拥有非常好的运行性能。
What if you know your OLTP searches should use the same execution plan for different binding values?
要是你知道你的OLTP搜索对不同绑定值应该使用相同执行计划又该怎么办呢?
Games are not like decision support system (DSS) or Online Transaction Processing (OLTP) systems at all.
游戏与决策支持系统(DSS)和在线事务处理(OLTP)系统完全不一样。
In a nutshell, short queries and OLTP transactions are faster as prepared statements with parameter markers.
总而言之,短小的查询和OLTP事务就像含参数占位符的预置语句一样,具有更快的速度。
Sequential scans are typical in decision support system (DSS) applications but rare with OLTP access patterns.
顺序扫描一般在决策支持系统(DSS)应用程序中很常见,但很少出现在OLTP访问模式中。
New features enhance OLTP data security, OLTP performance, data warehouse performance, and administration.
新特性增强了OLTP数据安全性、OLTP性能、数据仓库性能和管理。
Online transaction Processing (OLTP), consisting of many transactions of varying complexity, mostly small.
联机事务处理(Online Transaction Processing, OLTP),包含许多不同复杂性的小型事务。
On OLTP systems, where user sessions are performing quick queries, tuning this parameter can be very important.
在OLTP系统上,用户会话执行快速查询,调节此参数可能非常重要。
Suppose a table in an OLTP database already has 6 or 7 indexes. Would I give a thumbs-up to adding another?
假设 OLTP数据库中的一个表已经拥有6 个或7 个索引,我还会赞成再添加一个吗?
Because the only table may be the hotspot unless it is partitioned, OLTP Systems typically don't work well with it.
除非进行分区,否则唯一的数据表会成为热点,OLTP系统通常在这方面都不太好。
The results are very relevant to any DBA that must maintain and tune an online transaction processing (OLTP) system.
结果与必须维护和调优在线事务处理(OLTP)系统的任何DBA密切相关。
This is especially important in the OLTP environment where transactions are huge and query response time is critical.
这在OLTP环境中尤为重要,该环境中的事务十分巨大,而且查询响应时间十分关键。
A key concept of SOA is to reuse assets across the enterprise, which is composed of both OLTP workloads and batch.
SOA有一个非常重要的概念,即在企业之间重用资产,它由OLTP工作负载和批处理组成。
While the TPC-C benchmark is very simple, it is nonetheless quite efficient in touching many aspects of OLTP processing.
虽然TPC - c基准非常简单,但是它在OLTP处理的很多方面仍然非常有效。
Finally, the clustering of the data is guaranteed and cannot become un-clustered, as is normally the case in OLTP systems.
最后,数据的集群受到保障,数据不会又变成非集群状态,在OLTP系统中就常常会出现这种情况。
应用推荐