Pre - requisite :
- Sound knowledge on Oracle SQL or any other RDBMS like postgres,Mysql or Sybase Mandatory
- Knowledge of Administration in other RDBMS desirabl
Course Content
Introduction to Oracle Sqltuning
Understand Oracle Architecture from the perspective of adeveloper
Understanding Query Optimizer
Understanding and Interpreting Execution Plans
Understand Various Joins like
- Nested Loop
- Sort Merge Joins
- Hash Joins
AUtotrace statistics
Understanding Histograms and Implement for Sql Tuning
Important Hints for Sql Tuning
Eliminate Fragmentation in tables to resolve Query Issue
Using Indexes and Its Various Scans
- Btree
- Bitmap
- Compressed Index
- Index Range Scan
- Index Unique Scan
- Index Fast Scan
- Index Fast FullScan
- Index Skip scan
Monitoring and Tracing sql’s
Sql Tuning Advisor
Understand Materialized Views for Performance
Summary
