Section outline

    • week 9 Book

      Teaching and Learning Methods to be Employed

      1.    Illustrated lecture on query processing pipeline

      2.    Lab: Using EXPLAIN in MySQL to analyse query execution plans

      3.    Index creation and performance comparison exercise

      4.    Collection of Assignment 3

       

      Learning Outcomes / Objectives

      By the end of this week, students should be able to:

      1.    Describe the steps in query processing from SQL statement to query result.

      2.    Explain the role of the query optimiser in a DBMS.

      3.    Understand relational algebra as the basis for query evaluation.

      4.    Describe the structure and benefits of database indexes.

      5.    Use MySQL's EXPLAIN statement to interpret a query execution plan.

      6.    Apply basic query optimisation techniques.

    • Query Optimisation Lab Page