IBM并没有发布优化器如何确定最佳存取路径的真正和深入的详细信息,但优化器是一个基于成本的优化器。
IBM does not publish the actual, in-depth details of how the optimizer determines the best access path, but the optimizer is a cost-based optimizer.
在使用RUNSTATS之后需要重新绑定使用静态SQL的应用程序,这样查询优化器就可以选择新统计信息所给出的最佳存取方案。
Rebind applications that use static SQL after using RUNSTATS so that the query optimizer can choose the best access plan given the new statistics.
然而,您可能仍然希望优化器基于用户传递给查询的值来查找最佳的存取计划。
However, you would still like the optimizer to find the best access plan based on the values that users have passed into the query.
同样的, XIA 也保证帮助用户从最佳的存取点找到内容,该点甚至可以不是一台主机服务器,这样就加快了信息提取同时也去除了多余的网络交通.
XIA likewise promises to help users find content wherever it is most accessible, even if this isn't a host server, speeding information retrieval while cutting redundant network traffic.
请确定连接埠(预设为27017)是可存取,或连接到它将会在…拙劣在最佳。
Make sure the port (27017 by default) is accessible, or connecting to it will be... awkward, at best.
请确定连接埠(预设为27017)是可存取,或连接到它将会在…拙劣在最佳。
Make sure the port (27017 by default) is accessible, or connecting to it will be... awkward, at best.
应用推荐