# Objectives
+ Describe the operators and data aggregators for tables and indexes
+ List the possible access paths for tables and indexes
+ Use indexes to improve query performance
+ Describe the aggregation function operators
+ Describe the operators for joins
+ List the possible access paths for joins
+ Describe the `TiFlash MPP` architecture
+ Use `TiFlash` to improve query performance
------------------------------------------------------------------------------
[no notes]