[1]赵康,李明东.基于成本的ORACLE子查询性能研究[J].西华师范大学学报(自然科学版),2013,34(03):265-270.[doi:10.16246/j.issn.1673-5072.2013.03.008]
 ZHAO Kang,LI Ming-dong.Cost-Based Performance Study of Oracle Subquery[J].Journal of China West Normal University(Natural Sciences),2013,34(03):265-270.[doi:10.16246/j.issn.1673-5072.2013.03.008]
点击复制

基于成本的ORACLE子查询性能研究()
分享到:

《西华师范大学学报(自然科学版)》[ISSN:1673-5072/CN:51-1699/N]

卷:
34
期数:
2013年03期
页码:
265-270
栏目:
出版日期:
2013-09-20

文章信息/Info

Title:
Cost-Based Performance Study of Oracle Subquery
作者:
赵康;李明东;
西华师范大学计算机学院;
Author(s):
ZHAO KangLI Ming-dong
( The Computer Department,West China Normal University,Nanchong,Sichuan 637009)
关键词:
oracle标量子查询内嵌视图嵌套子查询
Keywords:
oracle scalar subquery inline-view nested-subquery
分类号:
TP311.13
DOI:
10.16246/j.issn.1673-5072.2013.03.008
文献标志码:
A
摘要:
较详细介绍了oracle的标量子查询、内嵌视图、嵌套子查询、having子查询,总结了oracle 11gR2和以前版本执行计划的差异,并讨论了视图合并、子查询非嵌套化、子查询合并等技术,最后讨论了where子句和having子句对数据过滤的影响.
Abstract:
This paper describes scalar subquery,inline-view,nested-subquery,having subquery in detail summarizesthe difference between the oracle 11 gR2 and previous version of subquery execution plan,and discusses the technologyof view merge,subquery unnesting,subquery coalescing. Finally it discusses the effects of the where clauseand the having clause on data filtering.

参考文献/References:


[1] JONATHAN LEWIS. Cost-Based Oracle Fundamentals [M]. New York: Apress, 2006: 207 - 252.
[2] THOMAS KYTE. Effective Oracle by Design: Design and Build High-Performance Oracle Applications [M]. McGraw-Hill OsborneMedia, 2003: 504 - 510.
[3] KAREN MORTON,KERRY OSBORNE,ROBYN SANDS,RIYALSHAMSUDEEN,JARED STILL. Pro Oracle SQL [M].New York: Apress, 2010: 39 - 49, 325 - 371. 3
[4] GUY HARRISON. Oracle Performance Survival Guide [M]. United States of America: Prentice Hall,2010: 289 - 327.
[5] SRIKANTH BELLAMKONDA,ANGELA AMOR,RAFI AHMED,MOHAMED ZAIT,ANDREW WITKOWSKI,CHUNCHIEHLIN. Enhanced Subquery Optimizations in Oracle [J]. Journal Proceedings of the VLDB Endowment Volume 2 Issue2, 2009,8: 1366 - 1377 .

备注/Memo

备注/Memo:

收稿日期: 2013 - 03 - 16
作者简介: 赵康( 1986 - ) ,男,山西大同人,西华师范大学计算机学院硕士研究生,主要从事数据挖掘,管理信息系统研究.
通讯作者: 李明东( 1958 - ) ,男,四川广安人,西华师范大学计算机学院教授,主要从事数据挖掘,管理信息系统研究.
更新日期/Last Update: 2017-12-28