MySQL: INDEXES are awesome

Skip ad
77 Views

  • Thanks! Share it with your friends!

    You disliked this video. Thanks for the feedback!

brocode
Published
#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);
Category
Bro Code
Tags
mysql tutorial for beginners, sql tutorial for beginners, mysql course
Be the first to comment