Tag: tag

Oracle Index Unique Scan — B-tree path from root to single rowid

Optimizer Access Paths: index unique scan

Posted on by Sanjeeva Kumar

In our previous blog, we talked about the optimizer access path. Over the last few blogs, we have walked through different access paths one by one. In this blog, we will see how the index unique scan works — and why it is the most efficient index access path Oracle has to offer. Index unique Read more about Optimizer Access Paths: index unique scan[…]

Oracle Direct Path Read: Complete Performance Guide with Real Examples

Posted on by Sanjeeva Kumar

Have you ever wondered why some of your Oracle queries bypass the buffer cache entirely and read data directly from disk? Recently, we encountered this exact scenario while investigating performance issues in a data warehouse environment, and I wanted to share our findings about Oracle’s direct path read mechanism. Oracle Direct Path Read is a Read more about Oracle Direct Path Read: Complete Performance Guide with Real Examples[…]