1CREATE INDEX
2Creates an index named ‘idx_test’ on the first_name and surname columns of
3the users table. In this instance, duplicate values are allowed.
4CREATE INDEX idx_test
5ON users (first_name, surname);
6CREATE UNIQUE INDEX
7Creates an index named ‘idx_test’ on the first_name and surname columns of
8the users table. In this instance, duplicate values are allowed.
9CREATE UNIQUE INDEX idx_test
10ON users (first_name, surname);
11DROP INDEX
12Creates an index named ‘idx_test’ on the first_name and surname columns of
13the users table. In this instance, duplicate values are allowed.
14ALTER TABLE users
15DROP INDEX idx_test;