Oracle 10g SQL Statement Tuning Course

A good, informative and broadening course authored by Hasan Tonguç Yılmaz. It lasted for 4 days hands on course. As a brief it consists of following topics, and exercises:

• Oracle SQL hints
• Oracle performance related views, and PLSQL packages
• BULK collect
• SQL bind variables
• Heap, Index Organized, Partitioned, Clustered tables
• Oracle sources regarding SQL statements (SQL Reference: http://tahiti.oracle.com, Package examples: http://psoug.org/library.html, For problems , articles, and solutions: http://metalink.oracle.com/, http://otn.oracle.com, http://asktom.oracle.com/tkyte/)
• Indexes, FTS
• Join methods, join orders

I will add above list later!