首页>
外国专利>
System and a two-pass algorithm for determining the optimum access path for multi-table SQL queries
System and a two-pass algorithm for determining the optimum access path for multi-table SQL queries
展开▼
机译:用于确定多表SQL查询的最佳访问路径的系统和两遍算法
展开▼
页面导航
摘要
著录项
相似文献
摘要
An apparatus, article of manufacture and computer-based method is provided for determining the optimum join sequence for processing a query having a plurality of tables from a relational database stored in an electronic storage device having a database management system. The method is performed in two passes. The first pass is used for determining an optimum join sequence for joining the plurality of tables from the query. The second pass uses the optimum join sequence for creating a lowest cost access path plan for processing the query. The first pass performs successive steps until creation of a simulated composite table having all tables from the query, wherein each step creates a set of miniplans for simulating all possible joins of a predetermined subset of the query tables and uses a cost model calculations for estimating and saving the least expensive join from this set of joins.
展开▼