Lectures from the Infinite – Oracle SQL optimization

infiniteInfinite is inviting everyone to the lecture “Oracle SQL Optimization”. Lecture is being held on 29.05.2013 at 12:30-14:00 and on 5.06.2013 at 12:30-14:00 at room S120 at “Pentagon” building.

Lecture will be presented by: mgr inż. Marcin Skibiński

The main topics are:

  • Introduction to SQL optimization
  • SQL optimizers
  • Problems with optimizers
  • Data access methods
  • JOIN operators
  • Statistics and histograms
  • SQL hints
  • Application tracing and profiling