2-5-x DDL NOTES

Assignment needs to include the UNIQUE index in auto ddl : SAK-11821
- SAK-11821 - eliminate duplicates in ASSIGNMENT_SUBMISSION
  - CREATE UNIQUE INDEX ASN_SUB_SUB_INDEX ON ASSIGNMENT_SUBMISSION ( CONTEXT,SUBMITTER_ID );

SEARCHBUIDERITEM

Add columns to search to improve performance SAK-9865

create index isearchbuilderitem_sco on searchbuilderitem (itemscope);

Gradebook

create index GB_CATEGORY_GB_IDX on GB_CATEGORY_T (GRADEBOOK_ID);
create index GB_GRADABLE_OBJ_CT_IDX on GB_GRADABLE_OBJECT_T (CATEGORY_ID);

Messages/Forums (MFR)

SAK-13137

create index MFR_MEMBERSHIP_ITEM_I01_I on MFR_MEMBERSHIP_ITEM_T (t_surrogateKey);
create index MFR_MEMBERSHIP_ITEM_I02_I on MFR_MEMBERSHIP_ITEM_T (a_surrogateKey);

SAK-13138

create index MFR_MESSAGE_T_IN_REPLY_TO_I on MFR_MESSAGE_T (IN_REPLY_TO);
create index MFR_TOPIC_T_UUID_I on MFR_TOPIC_T (UUID);