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);
