Sampath Sampath - 1 year ago 223
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);
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download