| 基于成本的数据库查询优化浅析 |
| |
| 引用本文： | 崔育礼,尹长青.基于成本的数据库查询优化浅析[J].数字社区&智能家居,2008,3(12):1540-1541. |
| |
| 作者姓名： | 崔育礼 尹长青 |
| |
| 作者单位： | 同济大学软件学院,上海201804 |
| |
| 摘 要： | 主要介绍基于成本的数据库查询优化的一些基本概念，针对多表连接的三种方法：嵌套循环链接、归并连接和混合连接进行分析和阐述．并成本估算，列出估算公式，
|
| 关 键 词： | 数据库系统 成本 存取路径 连接顺序 连接方法 NLJ MJ Hybrid Join |
On Cost Based Database Query Optimization |
| |
| CUI Yu-li,YIN Chang-qing.On Cost Based Database Query Optimization[J].Digital Community & Smart Home,2008,3(12):1540-1541. |
| |
| Authors: | CUI Yu-li YIN Chang-qing |
| |
| Affiliation: | (School of Software Engineering, Tongji University, Shanghai 201804, China) |
| |
| Abstract: | Mainly presents some basic concept of database query optimization, and analyze the three multi-table join methods： nested loop join, merge join and hybrid join,give the cost of each join methods. |
| |
| Keywords: | DBMS cost access path join sequence join methods NLJ MJ Hybrid Join |
| 本文献已被 维普 等数据库收录！ |
|
