SQL-complete-tutorial

1
EXPLAIN SELECT customer_id FROM customers WHERE state = 'CA';
2

3
CREATE INDEX idx_state ON customers (state);
4

5
-- Write a query to find customers with more than
6
-- 1000 points.
7

8
EXPLAIN SELECT customer_id
9
FROM customers
10
WHERE points > 1000;
11

12
CREATE INDEX idx_points ON customers (points);
13

14
SHOW INDEXES IN customers;
15
ANALYZE TABLE customers;
16

17
SHOW INDEXES IN orders;
18

19
/* 
20
The PRIMARY key index is also called a CLUSTERED index, which is
21
automatically created when a primary key is set. 
22
*/