Sampath Sampath - 1 month ago 6
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
 create index stu_sub_ind on student_subjects(roll_num, subject);