MySQL: INDEXES are awesome

#mysql #tutorial #course

-- INDEX (BTree data structure)
-- Indexes are used to find values within a specific column more quickly
-- MySQL normally searches sequentially through a column
-- The longer the column, the more expensive the operation is
-- UPDATE takes more time, SELECT takes less time

-- Single column index
CREATE INDEX last_name_idx
ON customers (last_name);

-- Multi column index
CREATE INDEX last_name_first_name_idx
ON customers (last_name, first_name);