Posted by rcamarda on 10/03/18 11:52

I have not partitioned the table. Here are the indexes:
CREATE INDEX CLASS_ATTENDANCE_ID ON
"dbo"."F_BI_Class_Attendance_Detail" ( "CLASS_ATTENDANCE_ID" );
CREATE INDEX CLASS_CAMPUS_ID ON "dbo"."F_BI_Class_Attendance_Detail" (
"CLASS_CAMPUS_ID" );
CREATE INDEX STUDENT_ID ON "dbo"."F_BI_Class_Attendance_Detail" (
"STUDENT_ID" );
CREATE INDEX FULL_CLASS_ID ON "dbo"."F_BI_Class_Attendance_Detail" (
"FULL_CLASS_ID" );
CREATE INDEX SESSION_ID ON "dbo"."F_BI_Class_Attendance_Detail" (
"SESSION_ID" );
CREATE INDEX MEETING ON "dbo"."F_BI_Class_Attendance_Detail" (
"MEETING" );
CREATE INDEX PRESENT ON "dbo"."F_BI_Class_Attendance_Detail" (
"PRESENT" );
CREATE INDEX SESSION_SKEY ON "dbo"."F_BI_Class_Attendance_Detail" (
"SESSION_SKEY" );
CREATE INDEX STUDENT_SKEY ON "dbo"."F_BI_Class_Attendance_Detail" (
"STUDENT_SKEY" );
CREATE INDEX CLASS_CAMPUS_SKEY ON "dbo"."F_BI_Class_Attendance_Detail"
( "CLASS_CAMPUS_SKEY" );

[Back to original message]