一个特定sql语句的存取计划是在绑定时生成的。
The access plan for a given SQL statement is generated at bind time.
清单9.value . sql的存取计划。
这会增加一些编译负载,但却能够产生一个最优的存取计划。
This brings little overhead for compiling, but gives an optimal access plan.
列表2显示了当这个项目已经被打开时如何转换它的存取类型。
Listing 2 shows how to switch the type of access when the project is already open.
所以让我们来看一种更具表现力的存取节点的方式:使用搜索。
Therefore, let's take a look at more expressive ways to access nodes, using search.
您还需要将一些简单的存取器方法添加到SimpleNode。
You also need to add a few simple accessor methods to SimpleNode.
除非子集群重新加入集群,否则将永远无法获得磁盘组的存取权限。
The subcluster which commits suicide should never gain access to the disk groups without joining the cluster again.
这意味着优化器将始终尝试为每个查询制定减少总体成本的存取路径。
This means the optimizer will always attempt to formulate an access path for each query that reduces overall cost.
清单11.pmarker . sql的存取计划。
如果值从0变成1,那么之前所使用的存取计划可能并不是最好的。
The access plan previously used may not be the best one if the value is changed from 0 to 1.
在斯塔尔出现之前,没人因为没有报告合法资金的存取被指控失职。
Until Starr came along, no one had ever been indicted for a negligent failure to report deposits or withdrawals of legitimate funds.
该参数值较高可能会影响优化器在缓冲池使用中对比较保守的存取方案的选择。
Higher values for this parameter can influence the optimizer to choose access plans that are more conservative in buffer pool usage.
将来父线程对num_proc1的存取会导致从该高速缓存线路的数据读入。
Future access to num_proc1 by the parent thread results in the reading in of the data from the cache line.
您可以从以上步骤看到,这个优化器基于可用的统计信息选择了最优的存取计划。
As you've seen in the steps above, the optimizer selects the optimal access plan based on available statistics.
它分析sql语句并确定可以满足每条语句的最有效的存取路径(请参阅图1)。
It analyzes SQL statements and determines the most efficient access path available for satisfying each statement (see Figure 1).
读取和写入原子变量与读取和写入对可变变量的访问具有相同的存取语义。
Reads and writes of atomic variables have the same memory semantics as read and write access to volatile variables.
图5按照WebSpherePortal提供的存取控制说明了委派的管理模型。
Figure 5 illustrates the delegated administration model as provided by WebSphere Portal access control.
然而,您可能仍然希望优化器基于用户传递给查询的值来查找最佳的存取计划。
However, you would still like the optimizer to find the best access plan based on the values that users have passed into the query.
也许语言和交际提供了我们能够得到的早期警告信号,也可以作为努力进行干预的存取点。
So perhaps language and communication might provide early warning signs that might be picked up and also serve as an access point for trying to develop interventions.
比如,一些软件可以帮助你整理大量的用户和产品细节,允许你方便快捷的存取。
For instance, some software lets you organize a wide array of customer and product particulars, allowing quick and easy access.
reservation通过限制其他系统对磁盘的存取和写入来防止对磁盘数据的损坏。
The reservation prevents disk data corruption by restricting other systems from accessing and writing to the disks.
在这种情况下,优化器会创建的存取计划都是不一样的,这在用户输入为0时可能不是最优的。
In this case, the optimizer creates a different access plan, which may not be optimal if the user input is 0.
这个问题的正确解决方案是通过添加正确的索引改进有问题的sql语句的存取方案。
The true solution to this problem is to improve the access plan for problematic SQL statements by adding the correct indexes.
我们将要讨论的新类的最后一个方面是LinkedHashMap的存取顺序选项。
The last aspect of the new classes we'll examine is the access order option for the LinkedHashMap.
参数化查询的主要性能好处是优化器可以制定在重复执行语句时能够再使用的存取路径。
The key performance benefit of parameterized queries is that the optimizer can formulate an access path that can be reused over repeated executions of the statement.
计算机专家和工程师们正在探索通过搜索算法、界面设计以及社会媒体平台等方式为公众提供信息的存取。
Computer Scientists and Engineers are discovering ways to make information accessible to the public using search algorithms, interface design, and social media platforms.
此外,数据库可以更好地理解它存储的数据的状态,从而可以生成到数据的更有效和动态的存取路径。
In addition, the database can have a better understanding of the state of the data it stores, and thereby can produce a more efficient and dynamic access path to the data.
通过专门的数据服务集中化所有企业数据的存取要求业务服务的所有数据存取也通过这些数据服务完成。
Centralization of access to all of the enterprise data through specialized data services requires business services to use them for all of the data access.
不可变属性的存取器将总是具有值引用,因而调用的任何一方都不需要防御性复制,这使得它们效率更高。
Accessors for immutable properties will always have value semantics and do not need the defensive copying on either side of the call, making them more efficient.
仔细看大多数的Rails应用都执行良好,但是很多Model 操作都可以经由调校降低对资料库的存取次数。
With a little attention, though, most Rails applications can be made to perform very well. Model requests often need tuning to reduce the number of database accesses required.
应用推荐