Application Considerations

• Eliminate Use Of Rowid’s In DSA
• Try To Eliminate Views
• Avoid The Use Of OUTER JOINS
• Rewrite Correlated Subqueries To Use Joins Instead
• Consider Locking Requirements - Page Vs Row

Previous slide

Next slide

Back to first slide

View graphic version