Sampath Sampath - 1 year ago 168
SQL Question

Code for creating index named stu_sub_ind

what is the code that will create an index named stu_sub_ind on the columns roll_num and subject of the student_subjects table?

Answer Source
 create index stu_sub_ind on student_subjects(roll_num, subject);