Oracle 高性能 SQL 引擎剖析：Oracle SQL 优化与调优技术详解作者：黄玮

Oracle6

220

85页

12次

2021-07-19

10墨值下载

Oracle 高性能 SQL 引擎剖析：Oracle SQL 优化与调优技术详解作者：黄玮

资源下载：http://www.HelloDBA.com

Oracle SQL 优化与调优技术详解

优化与调优技术详解优化与调优技术详解

优化与调优技术详解

附录

附录附录

附录：

：：

：Oracle SQL 提示

提示提示

提示

黄玮

黄玮黄玮

黄玮

www.HelloDBA.com

本电子文档为《Oracle 高性能SQL引擎剖析：Oracle SQL 优化与调优技术详解》一书的附

录部分。作为对该书的补充，帮助读者理解和掌握“提示”这一项在SQL优化中使用的这一重

要辅助手段。

Oracle 高性能 SQL 引擎剖析：Oracle SQL 优化与调优技术详解作者：黄玮

资源下载：http://www.HelloDBA.com

索引

索引索引

索引

ORACLE SQL 优化与调优技术详解

优化与调优技术详解优化与调优技术详解

优化与调优技术详解 .................................................................................... 1

附录

附录附录

附录：

：：

：提示

提示提示

提示（

（（

（HINT）

））

）的含义和示例

的含义和示例的含义和示例

的含义和示例 ................................................................................................... 9

SQL 特性 ....................................................................................................................................... 9

访问路径提示............................................................................................................................. 11

CLUSTER ............................................................................................................................. 11

HASH ................................................................................................................................... 11

ROWID ................................................................................................................................ 12

FULL .................................................................................................................................... 12

INDEX .................................................................................................................................. 12

INDEX_ASC ......................................................................................................................... 12

INDEX_DESC ....................................................................................................................... 13

NO_INDEX .......................................................................................................................... 13

INDEX_FFS .......................................................................................................................... 13

NO_INDEX_FFS ................................................................................................................... 13

INDEX_RRS.......................................................................................................................... 13

INDEX_SS ............................................................................................................................ 14

INDEX_SS_ASC .................................................................................................................... 14

INDEX_SS_DESC .................................................................................................................. 14

NO_INDEX_SS ..................................................................................................................... 15

INDEX_RS_ASC ................................................................................................................... 15

INDEX_RS_DESC ................................................................................................................. 15

AND_EQUAL ....................................................................................................................... 15

INDEX_COMBINE ................................................................................................................ 16

INDEX_JOIN ........................................................................................................................ 16

BITMAP_TREE ..................................................................................................................... 16

USE_INVISIBLE_INDEXES .................................................................................................... 17

NO_USE_INVISIBLE_INDEXES ............................................................................................. 17

关联提示 .................................................................................................................................... 17

NL_AJ .................................................................................................................................. 17

HASH_AJ ............................................................................................................................. 17

MERGE_AJ .......................................................................................................................... 18

USE_HASH .......................................................................................................................... 18

NO_USE_HASH ................................................................................................................... 18

USE_MERGE ....................................................................................................................... 19

NO_USE_MERGE ................................................................................................................ 19

USE_NL ............................................................................................................................... 19

USE_NL_WITH_INDEX ........................................................................................................ 19

NO_USE_NL ........................................................................................................................ 20

USE_MERGE_CARTESIAN ................................................................................................... 20

LEADING ............................................................................................................................. 20

USE_ANTI............................................................................................................................ 20

USE_SEMI ........................................................................................................................... 21

Oracle 高性能 SQL 引擎剖析：Oracle SQL 优化与调优技术详解作者：黄玮

资源下载：http://www.HelloDBA.com

NATIVE_FULL_OUTER_JOIN ............................................................................................... 21

NO_NATIVE_FULL_OUTER_JOIN ........................................................................................ 22

NO_CARTESIAN .................................................................................................................. 22

ORDERED ............................................................................................................................ 22

PX_JOIN_FILTER .................................................................................................................. 23

NO_PX_JOIN_FILTER .......................................................................................................... 23

NL_SJ .................................................................................................................................. 23

HASH_SJ ............................................................................................................................. 23

MERGE_SJ ........................................................................................................................... 24

NO_SEMIJOIN ..................................................................................................................... 24

SEMIJOIN ............................................................................................................................ 24

SWAP_JOIN_INPUTS ........................................................................................................... 25

NO_SWAP_JOIN_INPUTS ................................................................................................... 25

概要数据提示............................................................................................................................. 25

QB_NAME ........................................................................................................................... 25

DB_VERSION ....................................................................................................................... 26

IGNORE_OPTIM_EMBEDDED_HINTS ................................................................................. 26

IGNORE_WHERE_CLAUSE .................................................................................................. 26

NO_ACCESS ........................................................................................................................ 26

OPTIMIZER_FEATURES_ENABLE ......................................................................................... 27

OPT_PARAM ....................................................................................................................... 27

OUTLINE ............................................................................................................................. 27

OUTLINE_LEAF .................................................................................................................... 28

RBO_OUTLINE .................................................................................................................... 28

查询转换提示............................................................................................................................. 28

ANTIJOIN ............................................................................................................................ 28

COALESCE_SQ ..................................................................................................................... 28

NO_COALESCE_SQ ............................................................................................................. 29

ELIMINATE_JOIN ................................................................................................................ 29

NO_ELIMINATE_JOIN ......................................................................................................... 29

ELIMINATE_OBY ................................................................................................................. 29

NO_ELIMINATE_OBY .......................................................................................................... 30

EXPAND_GSET_TO_UNION ................................................................................................ 30

NO_EXPAND_GSET_TO_UNION ......................................................................................... 30

EXPAND_TABLE .................................................................................................................. 30

NO_EXPAND_TABLE ........................................................................................................... 31

STAR ................................................................................................................................... 31

STAR_TRANSFORMATION .................................................................................................. 31

NO_STAR_TRANSFORMATION ........................................................................................... 32

FACT ................................................................................................................................... 32

NO_FACT ............................................................................................................................ 32

FACTORIZE_JOIN ................................................................................................................ 32

NO_FACTORIZE_JOIN ......................................................................................................... 33

MATERIALIZE ...................................................................................................................... 33

INLINE ................................................................................................................................. 34

MERGE ................................................................................................................................ 34

of 85

10墨值下载

oracle sql 优化与调优技术详解黄玮

文档被以下合辑收录

专家专栏 | 黄玮（共9篇）

黄玮（Fuyuncat），资深Oracle DBA，从事Oracle数据库管理、维护与开发工作十余年，有丰富的大型数据库设计、开发与维护方面的经验。2005年创建个人网站www.HelloDBA.com，致力于数据库底层技术的研究，整理和发布了大量关于数据库系统底层机制、存储结构、性能调优以及基础算法方面的文章，获得广大同行的高度评价。

关注

文档被以下合辑收录

评论