Posted by rcamarda on 09/30/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" );

• Next in forum: BCP using ODBC - problem with unique identifier
• Prev in forum: Re: Newby DTS Question
• Thread view: Re: Smarter Table build - might split the table

[Reply to this message]