了解oracle数据库数据访问机制

来自另一个问题:

Full table scans, index range scans, fast full index scans, nested loops, merge join, hash joins etc. are simply access mechanisms that must be understood by the analyst

全表扫描,索引范围扫描,快速完整索引扫描,嵌套循环,合并连接,散列连接等只是分析人员必须理解的访问机制

Can someone explain each one and also provide where I can do some further reading on them?

有人可以解释每一个,并提供我可以进一步阅读它们的地方吗?

4 个解决方案

#1

For more on the joins, I would recommend reading some articles from Jonathan Lewis:

有关联接的更多信息,我建议您阅读Jonathan Lewis的一些文章:

Nested Loop Join

嵌套循环连接

Hash Join
Merge Join

For more info on reading Execution Plans and interpreting what they mean I would recommend the book:

有关阅读执行计划和解释其含义的更多信息,我会推荐这本书:

Troubleshooting Oracle Performance by Christian Antognini

Christian Antognini对Oracle性能进行故障排除

#2

http://download.oracle.com/docs/cd/E11882_01/server.112/e16638/optimops.htm#i21299

Chapter 11

Section 11.3 Overview of Joins

第11.3节连接概述

#3

For starters I recommend the relevant section of Oracle Database Concepts.

对于初学者,我推荐Oracle Database Concepts的相关部分。

If you want more detail, you can refer to the Performance Tuning Guide as Robert indicated.

如果您需要更多详细信息,可以参考Robert指出的性能调整指南。

#4

Great questions. I found these articles quite helpful for understanding these specific topics.

好问题。我发现这些文章对于理解这些特定主题非常有帮助。

Oracle HASH Joins:

Oracle HASH加入:

Oracle INDEX-MERGE Joins:

Oracle INDEX-MERGE加入:

#1