Starting with short introduction about different ways of query optimization, participants will be engaged in exploring and explaining different types (query, join and table) of query optimizer hints.