|All Oracle Tutorials||
Oracle SQL Tuning with Direct and Indirect Reads
|Oracle Consultants Available|
What is an indirect read? What is a direct read? How do they impact the performance of my Oracle SQL execution?
Learn this and more in this free tutorial from SkillBuilders. Oracle Master DBA John Watson will explain and demonstrate what direct / indirect reads are, pros and cons, why they can cause instability in the performance of your SQL (unpredictable response time), why stored outlines, SQL plan baselines and hints usually don't help.
Perhaps most importantly, John will tell you what you can do about it.
Intended Audience: Experience Oracle DBA's, developers and anyone with Oracle SQL tuning experience.