
CREATE TABLE students
  (id INTEGER PRIMARY KEY,
   name varchar(40),
   grade INTEGER,
   gpa FLOAT,
   tardies INTEGER);
   
INSERT INTO students (id, name, grade, gpa, tardies)
  VALUES (1,'Jake', 12, 3.5, 4);
INSERT INTO students (id, name, grade, gpa, tardies)
  VALUES (2,'Emily', 10, 3.7, 2);
INSERT INTO students (id, name, grade, gpa, tardies)
  VALUES (3,'Sam', 11, 3.5, 3);
INSERT INTO students (id, name, grade, gpa, tardies)
  VALUES (4,'Jordan', 10, 3.6, 2);
INSERT INTO students (id, name, grade, gpa, tardies)
  VALUES (5,'Victoria', 9, 3.2, 3);  

INSERT INTO students (id, name, grade, gpa, tardies)
  VALUES (6,'Antony', 19, 3.2, 3);  
 
create view v_students 
with schemabinding 
as
     select name, grade, gpa, tardies
     from dbo.students 

CREATE UNIQUE CLUSTERED INDEX  CX_v_students
ON dbo.v_students(name, grade, gpa, tardies); 


Select * from v_students WITH (INDEX(CX_v_students))