发明申请
US20050060285A1 Query optimization via a partitioned environment 有权
通过分区环境进行查询优化

Query optimization via a partitioned environment
摘要:
Systems, methods, and articles of manufacture for improving the efficiency of executing a query are provided. Queries frequently issued in a primary processing environment (e.g., a primary logical partition) may be run in a background processing environment (e.g., a background logical partition) with different access plans to determine the access plan that results in the least execution time. For some embodiments, in an effort to avoid executing queries that may have an adverse system-wide impact, selected queries may be analyzed in the background processing environment prior to being executed. This analysis may be performed to ensure the execution time of the query will not exceed a specified threshold, and/or will not result in excessive contention when executed in the primary processing environment.
公开/授权文献
信息查询
0/0