CREATE INDEX name_index ON class(NAME) CREATE VIEW class_view AS SELECT * FROM class SELECT * FROM class_view