Creating Indexes in MySQL

Hands-On Lab


Photo of Matthew Pearson

Matthew Pearson

Linux Training Architect II in Content





The MySQL server allows the creation of indexes which improve the speed of operations within a database table. In this Lab, you will be tasked with creating new indexes on existing tables, creating a new table with an index, and deleting an existing index from a table. Completing this lab will demonstrate a working knowledge of indexes in MySQL.

What are Hands-On Labs?

Hands-On Labs are scenario-based learning environments where learners can practice without consequences. Don't compromise a system or waste money on expensive downloads. Practice real-world skills without the real-world risk, no assembly required.