海翔 数据库查询优化技术--PostgreSQL的查询优化器

《海翔 数据库查询优化技术--PostgreSQL的查询优化器》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、http://blog.163.com/li_hx/数据库查询优化技术TheQueryOptimizeEngineOfPostgreSQL(9.2.3)LiHaiXiang2013-101http://blog.163.com/li_hx/数据库查询优化技术1Adatabasepractitioner2Direction:DatabasePostgreSQLMySQLBigDataetc3Blog:http://blog.163.com/hx_li4Email:database_XX@126.com5I

2、`dliketosharetechnologywithfriendsWhoamI?2http://blog.163.com/li_hx/数据库查询优化技术1WhatisthetechnologyOfQueryOptimization？2WhatistheQueryOptimizationTechnologyOfPostgreSQL？3HowtoimplementtheQueryOptimizationOfPostgreSQL？3http://blog.163.com/li_hx/数据库查询优化技术1Th

3、eTechnologyOfQueryOptimization1.Queryreuse①Thequeryresultreuse②Thequeryplanreuse2.TheRuleOfQueryRewrite①BasedonRelationalAlgebraandHeuristicRule②ViewRewrite、Sub-queryOptimization、EquivalentPredicateRewrite、ConditionSimplification、OuterJoinElimination、Joi

4、nElimination、NestJoinElimination③SematicOptimization3.TheAlgorithmOfQueryOptimization①SingleTableScanAlgorithm②TwoTableJoinAlgorithm③Multi-tableJoinAlgorithm4.ParallelQueryOptimization5.DistributeQueryOptimization4http://blog.163.com/li_hx/数据库查询优化技术2TheQ

5、ueryOptimizationTechnologyOfPostgreSQL1.Queryreuse------PostgreSQL9.2.3NotSupport①Thequeryresultreuse②Thequeryplanreuse2.TheRuleOfQueryRewrite①BasedonRelationalAlgebraandHeuristicRule②ViewRewrite、Sub-queryOptimization、EquivalentPredicateRewrite、Condition

6、Simplification、OuterJoinElimination、JoinElimination、NestJoinElimination③SematicOptimization3.TheAlgorithmOfQueryOptimization①SingleTableScanAlgorithm②TwoTableJoinAlgorithm③Multi-tableJoinAlgorithm4.ParallelQueryOptimization5.DistributeQueryOptimization5h

7、ttp://blog.163.com/li_hx/数据库查询优化技术3HowtoimplementtheQueryOptimizationOfPostgreSQL？Corequestion1：HowtoimplementtheQueryOptimizationofPostgreSQL?6http://blog.163.com/li_hx/数据库查询优化技术Howtoimplementthe3QueryOptimizationOfPostgreSQL？3.1QueryOptimizerFrame3.2Th

8、eSub-queryOptimizationTechnology3.3OtherQueryOptimizationTechnology7SQLStatementParser：LexcialParse、Synataxhttp://blog.163.com/li_hx/Parse、SematicCheckQueryOptimizer数据库查询优化技术3.1Rewriter：QueryRewrite（ViewRewrite）plannerfunc