Geek asks and answers

Understanding Oracle Database Access Mechanisms

From another question :

Full table scans, index range scans, fast full index scans, nested loops, merge combining, hash joins, etc. just access mechanisms that should be understood by the analyst

Can someone explain each of them, and also provide where I can continue reading?

+3
source share
4 answers

For more on joining, I would recommend reading some of Jonathan Lewis's articles:

For more information on reading implementation plans and interpreting what they mean, I would recommend the book:

Oracle Performance Christian Antognini

+4

For starters, I recommend the appropriate section on Oracle Database Concepts.

If you need more information, you can refer to the performance tuning guide , as Robert pointed out.

+1
source

Great questions. I found these articles very helpful in understanding these specific topics.

Oracle HASH integrates:

Oracle INDEX-MERGE Joins:

0
source

More articles:


All Articles