--
--  database indexation initialization
--

-- index for Actor
CREATE INDEX IDX_ActCivID ON Actor (ActCivID);
CREATE INDEX IDX_ActStaID ON Actor (ActStaID);
CREATE INDEX IDX_ActSitID ON Actor (ActSitID);
CREATE INDEX IDX_ActAdeID ON Actor (ActAdeID);
CREATE INDEX IDX_ActDeptID ON Actor (ActDeptID);
CREATE INDEX IDX_MC_ActSector ON MvaActSector (MvaColID);
CREATE INDEX IDX_MC_ActLngID ON MvaActLngID (MvaColID);
CREATE INDEX IDX_MT_ActLngID ON MvaActLngID (MvaText);
CREATE INDEX IDX_ActManager ON Actor (ActManager);
CREATE INDEX IDX_ActBackup ON Actor (ActBackup);
CREATE INDEX IDX_ActAssistant ON Actor (ActAssistant);
CREATE INDEX IDX_ActPicID ON Actor (ActPicID);
CREATE INDEX IDX_MC_ActCsoID ON MvaActCsoID (MvaColID);
CREATE INDEX IDX_MT_ActCsoID ON MvaActCsoID (MvaText);
CREATE INDEX IDX_MC_ActCpoID ON MvaActCpoID (MvaColID);
CREATE INDEX IDX_MT_ActCpoID ON MvaActCpoID (MvaText);
CREATE INDEX IDX_MC_ActNcoID ON MvaActNcoID (MvaColID);
CREATE INDEX IDX_MT_ActNcoID ON MvaActNcoID (MvaText);
CREATE INDEX IDX_MC_ActRoles ON MvaActRoles (MvaColID);
CREATE INDEX IDX_MT_ActRoles ON MvaActRoles (MvaText);
CREATE INDEX IDX_ActDecisionProfile ON Actor (ActDecisionProfile);
CREATE INDEX IDX_MC_ActDshIDs ON MvaActDshIDs (MvaColID);
CREATE INDEX IDX_MT_ActDshIDs ON MvaActDshIDs (MvaText);
CREATE INDEX IDX_ActCtrID ON Actor (ActCtrID);
CREATE INDEX IDX_ActCotID ON Actor (ActCotID);
CREATE INDEX IDX_ActDashID ON Actor (ActDashID);
CREATE INDEX IDX_ActSyncType ON Actor (ActSyncType);
CREATE INDEX IDX_ActSyncModel ON Actor (ActSyncModel);
CREATE INDEX IDX_ActLngPrinc ON Actor (ActLngPrinc);
CREATE INDEX IDX_ActTzoID ON Actor (ActTzoID);
CREATE INDEX IDX_ActTymID ON Actor (ActTymID);
CREATE INDEX IDX_MC_ActPermLics ON MvaActPermLics (MvaColID);
CREATE INDEX IDX_MC_ActFloatLics ON MvaActFloatLics (MvaColID);
CREATE INDEX IDX_MC_ActSyncOptions ON MvaActSyncOptions (MvaColID);
CREATE INDEX IDX_ActPartitionID ON Actor (ActPartitionID);
CREATE INDEX IDX_ActEmpSta ON Actor (ActEmpSta);
CREATE INDEX IDX_MC_ActPrevPwds ON MvaActPrevPwds (MvaColID);

-- index for Attachment
CREATE INDEX IDX_AttIcon ON Attachment (AttIcon);

-- index for AutoDisplayZone
CREATE INDEX IDX_AdzObjID ON AutoDisplayZone (AdzObjID);
CREATE INDEX IDX_MC_AdzPartitionID ON MvaAdzPartitionID (MvaColID);
CREATE INDEX IDX_MT_AdzPartitionID ON MvaAdzPartitionID (MvaText);

-- index for Dashboard
CREATE INDEX IDX_DshType ON Dashboard (DshType);
CREATE INDEX IDX_MC_DshPages ON MvaDshPages (MvaColID);
CREATE INDEX IDX_MT_DshPages ON MvaDshPages (MvaText);
CREATE INDEX IDX_DshActor ON Dashboard (DshActor);

-- index for DashboardPage
CREATE INDEX IDX_DspPage ON DashboardPage (DspPage);
CREATE INDEX IDX_DspDshID ON DashboardPage (DspDshID);

-- index for Department
CREATE INDEX IDX_DptType ON Department (DptType);
CREATE INDEX IDX_DptEnt ON Department (DptEnt);

-- index for DIExecution
CREATE INDEX IDX_DieModelID ON DIExecution (DieModelID);
CREATE INDEX IDX_DieFlag ON DIExecution (DieFlag);
CREATE INDEX IDX_DieArchiveID ON DIExecution (DieArchiveID);
CREATE INDEX IDX_DieFileID ON DIExecution (DieFileID);

-- index for DIModel
CREATE INDEX IDX_DimOrigin ON DIModel (DimOrigin);

-- index for EntIdentical
CREATE INDEX IDX_EidEntID1 ON EntIdentical (EidEntID1);
CREATE INDEX IDX_EidEntID2 ON EntIdentical (EidEntID2);

-- index for ExternalNotification
CREATE INDEX IDX_ExnActID ON ExternalNotification (ExnActID);
CREATE INDEX IDX_ExnSymID ON ExternalNotification (ExnSymID);

-- index for Field
CREATE INDEX IDX_FldObjID ON Field (FldObjID);
CREATE INDEX IDX_FldFltID ON Field (FldFltID);
CREATE INDEX IDX_FldTabID ON Field (FldTabID);
CREATE INDEX IDX_FldFobID ON Field (FldFobID);
CREATE INDEX IDX_FldDisplayPolicy ON Field (FldDisplayPolicy);
CREATE INDEX IDX_FldIndexPolicy ON Field (FldIndexPolicy);

-- index for FlOption
CREATE INDEX IDX_OptGroup ON FlOption (OptGroup);
CREATE INDEX IDX_OptType ON FlOption (OptType);
CREATE INDEX IDX_MC_OptValueList ON MvaOptValueList (MvaColID);

-- index for FlTask
CREATE INDEX IDX_TskRepetition ON FlTask (TskRepetition);
CREATE INDEX IDX_MC_TskDaysOfWeek ON MvaTskDaysOfWeek (MvaColID);
CREATE INDEX IDX_MT_TskDaysOfWeek ON MvaTskDaysOfWeek (MvaText);
CREATE INDEX IDX_TskInstance ON FlTask (TskInstance);
CREATE INDEX IDX_MC_TskActions ON MvaTskActions (MvaColID);
CREATE INDEX IDX_MT_TskActions ON MvaTskActions (MvaText);
CREATE INDEX IDX_TskBase ON FlTask (TskBase);

-- index for FlTaskLog
CREATE INDEX IDX_TslTskID ON FlTaskLog (TslTskID);

-- index for History
CREATE INDEX IDX_HisActID ON History (HisActID);
CREATE INDEX IDX_HisPerID ON History (HisPerID);
CREATE INDEX IDX_HisSilID ON History (HisSilID);
CREATE INDEX IDX_HisJouID ON History (HisJouID);
CREATE INDEX IDX_HisParentID ON History (HisParentID);
CREATE INDEX IDX_HisOldRefValue ON History (HisOldRefValue);
CREATE INDEX IDX_MC_HisOldMvaTextValue ON MvaHisOldMvaTextValue (MvaColID);
CREATE INDEX IDX_MC_HisOldMvaDateTimeVal0 ON MvaHisOldMvaDateTimeValue (MvaColID);
CREATE INDEX IDX_MC_HisOldMvaIntValue ON MvaHisOldMvaIntValue (MvaColID);
CREATE INDEX IDX_MC_HisOldMvaFloatValue ON MvaHisOldMvaFloatValue (MvaColID);
CREATE INDEX IDX_HisNewRefValue ON History (HisNewRefValue);
CREATE INDEX IDX_MC_HisNewMvaTextValue ON MvaHisNewMvaTextValue (MvaColID);
CREATE INDEX IDX_MC_HisNewMvaDateTimeVal1 ON MvaHisNewMvaDateTimeValue (MvaColID);
CREATE INDEX IDX_MC_HisNewMvaIntValue ON MvaHisNewMvaIntValue (MvaColID);
CREATE INDEX IDX_MC_HisNewMvaFloatValue ON MvaHisNewMvaFloatValue (MvaColID);

-- index for InformationPanel
CREATE INDEX IDX_InpIssuerID ON InformationPanel (InpIssuerID);
CREATE INDEX IDX_InpCatID ON InformationPanel (InpCatID);
CREATE INDEX IDX_InpTypID ON InformationPanel (InpTypID);
CREATE INDEX IDX_MC_InpReceiver ON MvaInpReceiver (MvaColID);
CREATE INDEX IDX_MT_InpReceiver ON MvaInpReceiver (MvaText);
CREATE INDEX IDX_MC_InpActWhoHaveRead ON MvaInpActWhoHaveRead (MvaColID);
CREATE INDEX IDX_MT_InpActWhoHaveRead ON MvaInpActWhoHaveRead (MvaText);

-- index for Label
CREATE INDEX IDX_LblCodeLng ON Label (LblCodeLng);

-- index for LinkZoneField
CREATE INDEX IDX_LzfAdzID ON LinkZoneField (LzfAdzID);
CREATE INDEX IDX_LzfFldID ON LinkZoneField (LzfFldID);

-- index for List
CREATE INDEX IDX_LstObjID ON List (LstObjID);

-- index for MatchCodeFields
CREATE INDEX IDX_McfFldID ON MatchCodeFields (McfFldID);
CREATE INDEX IDX_McfWfaID ON MatchCodeFields (McfWfaID);
CREATE INDEX IDX_McfMcrID ON MatchCodeFields (McfMcrID);

-- index for MatchCodeRules
CREATE INDEX IDX_McrObjID ON MatchCodeRules (McrObjID);

-- index for MatchCodeTemplate
CREATE INDEX IDX_McoObjID ON MatchCodeTemplate (McoObjID);
CREATE INDEX IDX_MC_McoMcfID ON MvaMcoMcfID (MvaColID);
CREATE INDEX IDX_MT_McoMcfID ON MvaMcoMcfID (MvaText);

-- index for Menu
CREATE INDEX IDX_MenSfwID ON Menu (MenSfwID);
CREATE INDEX IDX_MenIcon ON Menu (MenIcon);
CREATE INDEX IDX_MenMainList ON Menu (MenMainList);

-- index for MenuByRole
CREATE INDEX IDX_MbrRole ON MenuByRole (MbrRole);
CREATE INDEX IDX_MbrMenID ON MenuByRole (MbrMenID);

-- index for MenuElement
CREATE INDEX IDX_MelMenID ON MenuElement (MelMenID);
CREATE INDEX IDX_MelParentID ON MenuElement (MelParentID);

-- index for Messages
CREATE INDEX IDX_MsgCtyID ON Messages (MsgCtyID);
CREATE INDEX IDX_MC_MsgAttID ON MvaMsgAttID (MvaColID);
CREATE INDEX IDX_MT_MsgAttID ON MvaMsgAttID (MvaText);
CREATE INDEX IDX_MsgObjID ON Messages (MsgObjID);
CREATE INDEX IDX_MsgEvtID ON Messages (MsgEvtID);
CREATE INDEX IDX_MsgLngRef ON Messages (MsgLngRef);
CREATE INDEX IDX_MsgType ON Messages (MsgType);
CREATE INDEX IDX_MC_MsgMergedDocID ON MvaMsgMergedDocID (MvaColID);
CREATE INDEX IDX_MT_MsgMergedDocID ON MvaMsgMergedDocID (MvaText);
CREATE INDEX IDX_MC_MsgDocID ON MvaMsgDocID (MvaColID);
CREATE INDEX IDX_MT_MsgDocID ON MvaMsgDocID (MvaText);
CREATE INDEX IDX_MC_MsgAttFileName ON MvaMsgAttFileName (MvaColID);
CREATE INDEX IDX_MC_MsgPartitionID ON MvaMsgPartitionID (MvaColID);
CREATE INDEX IDX_MT_MsgPartitionID ON MvaMsgPartitionID (MvaText);

-- index for MetaDataFieldChange
CREATE INDEX IDX_MfcMocID ON MetaDataFieldChange (MfcMocID);
CREATE INDEX IDX_MfcFldID ON MetaDataFieldChange (MfcFldID);

-- index for MetaDataObjectChange
CREATE INDEX IDX_MocObjID ON MetaDataObjectChange (MocObjID);
CREATE INDEX IDX_MocMdtID ON MetaDataObjectChange (MocMdtID);
CREATE INDEX IDX_MocPolitique ON MetaDataObjectChange (MocPolitique);

-- index for MetaDataTransfer
CREATE INDEX IDX_MdtSource ON MetaDataTransfer (MdtSource);
CREATE INDEX IDX_MdtStatus ON MetaDataTransfer (MdtStatus);

-- index for Objects
CREATE INDEX IDX_MC_ObjRolesEdit ON MvaObjRolesEdit (MvaColID);
CREATE INDEX IDX_MC_ObjRoles ON MvaObjRoles (MvaColID);
CREATE INDEX IDX_MT_ObjRoles ON MvaObjRoles (MvaText);
CREATE INDEX IDX_MC_ObjRolesRead ON MvaObjRolesRead (MvaColID);
CREATE INDEX IDX_MC_ObjRolesCreate ON MvaObjRolesCreate (MvaColID);
CREATE INDEX IDX_MC_ObjRolesDelete ON MvaObjRolesDelete (MvaColID);
CREATE INDEX IDX_MC_ObjConnexObjs ON MvaObjConnexObjs (MvaColID);
CREATE INDEX IDX_MT_ObjConnexObjs ON MvaObjConnexObjs (MvaText);

-- index for Operation
CREATE INDEX IDX_OpeOpgID ON Operation (OpeOpgID);
CREATE INDEX IDX_OpeResult ON Operation (OpeResult);
CREATE INDEX IDX_OpeType ON Operation (OpeType);

-- index for OperationGroup
CREATE INDEX IDX_OpgType ON OperationGroup (OpgType);

-- index for Partition
CREATE INDEX IDX_PrtMode ON Partition (PrtMode);
CREATE INDEX IDX_PrtParentPart ON Partition (PrtParentPart);

-- index for PerIdentical
CREATE INDEX IDX_PidPerID1 ON PerIdentical (PidPerID1);
CREATE INDEX IDX_PidPerID2 ON PerIdentical (PidPerID2);

-- index for RefLocale
-- RelRefID skipped
-- RelLngID skipped
CREATE UNIQUE INDEX IDXS_000000002 ON RefLocale (RelRefID, RelLngID);

-- index for RefValues
CREATE INDEX IDX_RefTabID ON RefValues (RefTabID);

-- index for Requester
CREATE INDEX IDX_ReqTyrID ON Requester (ReqTyrID);
CREATE INDEX IDX_ReqLngID ON Requester (ReqLngID);
CREATE INDEX IDX_ReqType1 ON Requester (ReqType1);
CREATE INDEX IDX_ReqType2 ON Requester (ReqType2);
CREATE INDEX IDX_ReqType3 ON Requester (ReqType3);
CREATE INDEX IDX_ReqType4 ON Requester (ReqType4);
CREATE INDEX IDX_ReqType5 ON Requester (ReqType5);
CREATE INDEX IDX_ReqType6 ON Requester (ReqType6);
CREATE INDEX IDX_ReqType7 ON Requester (ReqType7);
CREATE INDEX IDX_ReqType8 ON Requester (ReqType8);
CREATE INDEX IDX_ReqType9 ON Requester (ReqType9);
CREATE INDEX IDX_ReqObjID ON Requester (ReqObjID);
CREATE INDEX IDX_ReqPopObj1 ON Requester (ReqPopObj1);
CREATE INDEX IDX_ReqPopObj2 ON Requester (ReqPopObj2);
CREATE INDEX IDX_ReqPopObj3 ON Requester (ReqPopObj3);
CREATE INDEX IDX_ReqPopObj4 ON Requester (ReqPopObj4);
CREATE INDEX IDX_ReqPopObj5 ON Requester (ReqPopObj5);

-- index for Site
CREATE INDEX IDX_SitKosID ON Site (SitKosID);
CREATE INDEX IDX_SitCtrID ON Site (SitCtrID);
CREATE INDEX IDX_SitAreID ON Site (SitAreID);
CREATE INDEX IDX_SitActID ON Site (SitActID);
CREATE INDEX IDX_SitPicID ON Site (SitPicID);

-- index for SLA
CREATE INDEX IDX_SlaSssID ON SLA (SlaSssID);
CREATE INDEX IDX_SlaObjID ON SLA (SlaObjID);
CREATE INDEX IDX_MC_SlaFldID ON MvaSlaFldID (MvaColID);
CREATE INDEX IDX_MT_SlaFldID ON MvaSlaFldID (MvaText);
CREATE INDEX IDX_SlaTzoID ON SLA (SlaTzoID);
CREATE INDEX IDX_MC_SlaJouID ON MvaSlaJouID (MvaColID);
CREATE INDEX IDX_MT_SlaJouID ON MvaSlaJouID (MvaText);
CREATE INDEX IDX_SlaMsgAlarm ON SLA (SlaMsgAlarm);
CREATE INDEX IDX_MC_SlaHolidays ON MvaSlaHolidays (MvaColID);
CREATE INDEX IDX_SlaMsgOver ON SLA (SlaMsgOver);
CREATE INDEX IDX_SlaMainFields ON SLA (SlaMainFields);
CREATE INDEX IDX_SlaField1 ON SLA (SlaField1);
CREATE INDEX IDX_SlaField2 ON SLA (SlaField2);
CREATE INDEX IDX_SlaField3 ON SLA (SlaField3);
CREATE INDEX IDX_SlaMsgDelay ON SLA (SlaMsgDelay);
CREATE INDEX IDX_SlaMsgFinalAlert ON SLA (SlaMsgFinalAlert);
CREATE INDEX IDX_SlaMsgDelayAlert ON SLA (SlaMsgDelayAlert);
CREATE INDEX IDX_SlaMsgOverAlert ON SLA (SlaMsgOverAlert);

-- index for SLAAlarm
CREATE INDEX IDX_SllTalID ON SLAAlarm (SllTalID);
CREATE INDEX IDX_SllSlsID ON SLAAlarm (SllSlsID);
CREATE INDEX IDX_MC_SllActID ON MvaSllActID (MvaColID);
CREATE INDEX IDX_MT_SllActID ON MvaSllActID (MvaText);
CREATE INDEX IDX_SllCause ON SLAAlarm (SllCause);

-- index for SLAState
CREATE INDEX IDX_SlsSLAID ON SLAState (SlsSLAID);
CREATE INDEX IDX_MC_SlsFieldActor ON MvaSlsFieldActor (MvaColID);
CREATE INDEX IDX_MT_SlsFieldActor ON MvaSlsFieldActor (MvaText);
CREATE INDEX IDX_MC_SlsRoles ON MvaSlsRoles (MvaColID);
CREATE INDEX IDX_MT_SlsRoles ON MvaSlsRoles (MvaText);
CREATE INDEX IDX_SlsValue1 ON SLAState (SlsValue1);
CREATE INDEX IDX_SlsValue2 ON SLAState (SlsValue2);
CREATE INDEX IDX_SlsValue3 ON SLAState (SlsValue3);

-- index for Software
CREATE INDEX IDX_SfwIcon ON Software (SfwIcon);
CREATE INDEX IDX_MC_SfwRoleHidden ON MvaSfwRoleHidden (MvaColID);
CREATE INDEX IDX_MT_SfwRoleHidden ON MvaSfwRoleHidden (MvaText);

-- index for Supplier
CREATE INDEX IDX_SplCtrID ON Supplier (SplCtrID);
CREATE INDEX IDX_MC_SplFamilles ON MvaSplFamilles (MvaColID);
CREATE INDEX IDX_MT_SplFamilles ON MvaSplFamilles (MvaText);
CREATE INDEX IDX_SplStatut ON Supplier (SplStatut);

-- index for Synchronization
CREATE INDEX IDX_SynActID ON Synchronization (SynActID);

-- index for SyncModel
CREATE INDEX IDX_SymType ON SyncModel (SymType);

-- index for TrashReport
CREATE INDEX IDX_TrpDieID ON TrashReport (TrpDieID);
CREATE INDEX IDX_TrpObjID ON TrashReport (TrpObjID);

-- index for TrashReportLine
CREATE INDEX IDX_TrlTrpID ON TrashReportLine (TrlTrpID);
CREATE INDEX IDX_TrlErrorCodeID ON TrashReportLine (TrlErrorCodeID);
CREATE INDEX IDX_TrlErrorField ON TrashReportLine (TrlErrorField);

-- index for WallUserConfig
CREATE INDEX IDX_WucTypObj ON WallUserConfig (WucTypObj);
CREATE INDEX IDX_WucSe2Id ON WallUserConfig (WucSe2Id);
CREATE INDEX IDX_WucActID ON WallUserConfig (WucActID);

-- index for Workflow
CREATE INDEX IDX_WkfObjID ON Workflow (WkfObjID);
CREATE INDEX IDX_WkfStatus ON Workflow (WkfStatus);
CREATE INDEX IDX_WkfMsgID ON Workflow (WkfMsgID);

-- index for WorkflowAction
CREATE INDEX IDX_WfaType ON WorkflowAction (WfaType);

-- index for XPage
CREATE INDEX IDX_XpgTargetObject ON XPage (XpgTargetObject);
CREATE INDEX IDX_XpgClass ON XPage (XpgClass);

-- index for XPageField
CREATE INDEX IDX_XpfXPageID ON XPageField (XpfXPageID);
CREATE INDEX IDX_XpfFieldType ON XPageField (XpfFieldType);

-- index for XPageSource
CREATE INDEX IDX_XpsTarget ON XPageSource (XpsTarget);
CREATE INDEX IDX_XpsDel ON XPageSource (XpsDel);
CREATE INDEX IDX_XpsEdit ON XPageSource (XpsEdit);

-- index for XPageUser
CREATE INDEX IDX_XpuLoginName ON XPageUser (XpuLoginName);

-- index for ZipCodeEntry
CREATE INDEX IDX_ZipCountry ON ZipCodeEntry (ZipCountry);

-- index for Action
CREATE INDEX IDX_AacRulID ON Action (AacRulID);

-- index for AutomationLog
CREATE INDEX IDX_AulRulID ON AutomationLog (AulRulID);
CREATE INDEX IDX_AulActionID ON AutomationLog (AulActionID);

-- index for AutomationParameter
CREATE INDEX IDX_AupTypID ON AutomationParameter (AupTypID);
CREATE INDEX IDX_AupAbsID ON AutomationParameter (AupAbsID);
CREATE INDEX IDX_AupAacID ON AutomationParameter (AupAacID);

-- index for AutomationRequester
CREATE INDEX IDX_AurTemID ON AutomationRequester (AurTemID);
CREATE INDEX IDX_AurAcoID ON AutomationRequester (AurAcoID);

-- index for AutomationTrigger
CREATE INDEX IDX_TrgAopID ON AutomationTrigger (TrgAopID);
CREATE INDEX IDX_TrgObjID ON AutomationTrigger (TrgObjID);
CREATE INDEX IDX_TrgRulID ON AutomationTrigger (TrgRulID);

-- index for Condition
CREATE INDEX IDX_AcoRulID ON Condition (AcoRulID);

-- index for Process
CREATE INDEX IDX_PrsStatus ON Process (PrsStatus);
CREATE INDEX IDX_PrsObject ON Process (PrsObject);
CREATE INDEX IDX_MC_PrsPartitionID ON MvaPrsPartitionID (MvaColID);
CREATE INDEX IDX_MT_PrsPartitionID ON MvaPrsPartitionID (MvaText);
CREATE INDEX IDX_PrsCategory ON Process (PrsCategory);

-- index for ProcessInstance
CREATE INDEX IDX_PriExecActID ON ProcessInstance (PriExecActID);
CREATE INDEX IDX_PriStatus ON ProcessInstance (PriStatus);
CREATE INDEX IDX_PriProcessObjType ON ProcessInstance (PriProcessObjType);
CREATE INDEX IDX_PriProcessID ON ProcessInstance (PriProcessID);
CREATE INDEX IDX_PriType ON ProcessInstance (PriType);

-- index for ProcessTask
CREATE INDEX IDX_PtaProcessID ON ProcessTask (PtaProcessID);
CREATE INDEX IDX_PtaIntAtvID ON ProcessTask (PtaIntAtvID);
CREATE INDEX IDX_MC_PtaRefDocID ON MvaPtaRefDocID (MvaColID);
CREATE INDEX IDX_MT_PtaRefDocID ON MvaPtaRefDocID (MvaText);
CREATE INDEX IDX_PtaActorRule ON ProcessTask (PtaActorRule);
CREATE INDEX IDX_PtaActorRuleActID ON ProcessTask (PtaActorRuleActID);
CREATE INDEX IDX_PtaIntStiID ON ProcessTask (PtaIntStiID);
CREATE INDEX IDX_MC_PtaIntRefMsgID ON MvaPtaIntRefMsgID (MvaColID);
CREATE INDEX IDX_MT_PtaIntRefMsgID ON MvaPtaIntRefMsgID (MvaText);

-- index for RequesterParameter
CREATE INDEX IDX_RepTypID ON RequesterParameter (RepTypID);
CREATE INDEX IDX_RepAurID ON RequesterParameter (RepAurID);

-- index for Rules
CREATE INDEX IDX_RulModeID ON Rules (RulModeID);

-- index for Signature
CREATE INDEX IDX_SigRulID ON Signature (SigRulID);

-- index for DecisionData
CREATE INDEX IDX_DdaType ON DecisionData (DdaType);
CREATE INDEX IDX_DdaStatus ON DecisionData (DdaStatus);
CREATE INDEX IDX_DdaObjID ON DecisionData (DdaObjID);
CREATE INDEX IDX_MC_DdaAuthRoles ON MvaDdaAuthRoles (MvaColID);
CREATE INDEX IDX_MT_DdaAuthRoles ON MvaDdaAuthRoles (MvaText);
CREATE INDEX IDX_DdaIcon ON DecisionData (DdaIcon);

-- index for DecisionFamilyProfile
CREATE INDEX IDX_DfpFamilyName ON DecisionFamilyProfile (DfpFamilyName);
CREATE INDEX IDX_DfpProfile ON DecisionFamilyProfile (DfpProfile);

-- index for DecisionIndicator
CREATE INDEX IDX_DinBeanName ON DecisionIndicator (DinBeanName);
CREATE INDEX IDX_DinVarDirection ON DecisionIndicator (DinVarDirection);
CREATE INDEX IDX_DinType ON DecisionIndicator (DinType);

-- index for DecisionIndicatorOrder
CREATE INDEX IDX_DioDinID ON DecisionIndicatorOrder (DioDinID);
CREATE INDEX IDX_DioDfpID ON DecisionIndicatorOrder (DioDfpID);

-- index for DecisionIndicatorValue
CREATE INDEX IDX_DivDinID ON DecisionIndicatorValue (DivDinID);
CREATE INDEX IDX_DivActorID ON DecisionIndicatorValue (DivActorID);

-- index for HelpDoc
CREATE INDEX IDX_HelParent ON HelpDoc (HelParent);

-- index for Paragraph
CREATE INDEX IDX_ParStyle ON Paragraph (ParStyle);
CREATE INDEX IDX_ParParent ON Paragraph (ParParent);
CREATE INDEX IDX_ParAttID ON Paragraph (ParAttID);

-- index for Cart
CREATE INDEX IDX_CrtSolID ON Cart (CrtSolID);
CREATE INDEX IDX_MC_CrtFaqID ON MvaCrtFaqID (MvaColID);
CREATE INDEX IDX_MT_CrtFaqID ON MvaCrtFaqID (MvaText);
CREATE INDEX IDX_CrtStatus ON Cart (CrtStatus);
CREATE INDEX IDX_CrtActID ON Cart (CrtActID);
CREATE INDEX IDX_CrtAttID ON Cart (CrtAttID);

-- index for Comments
CREATE INDEX IDX_CmtActID ON Comments (CmtActID);
CREATE INDEX IDX_CmtType ON Comments (CmtType);
CREATE INDEX IDX_CmtFahID ON Comments (CmtFahID);
CREATE INDEX IDX_CmtStatus ON Comments (CmtStatus);
CREATE INDEX IDX_CmtLngID ON Comments (CmtLngID);

-- index for FAQ
CREATE INDEX IDX_FaqLngID ON FAQ (FaqLngID);
CREATE INDEX IDX_FaqFahID ON FAQ (FaqFahID);
CREATE INDEX IDX_MC_FaqPartitionID ON MvaFaqPartitionID (MvaColID);
CREATE INDEX IDX_MT_FaqPartitionID ON MvaFaqPartitionID (MvaText);

-- index for FAQHeader
CREATE INDEX IDX_FahActID ON FAQHeader (FahActID);
CREATE INDEX IDX_FahCatID ON FAQHeader (FahCatID);
CREATE INDEX IDX_MC_FahKeyID ON MvaFahKeyID (MvaColID);
CREATE INDEX IDX_MT_FahKeyID ON MvaFahKeyID (MvaText);
CREATE INDEX IDX_FahCatLev1 ON FAQHeader (FahCatLev1);
CREATE INDEX IDX_FahSource ON FAQHeader (FahSource);
CREATE INDEX IDX_FahStatus ON FAQHeader (FahStatus);
CREATE INDEX IDX_FahOwnrActID ON FAQHeader (FahOwnrActID);
CREATE INDEX IDX_MC_FahPblChannel ON MvaFahPblChannel (MvaColID);
CREATE INDEX IDX_MT_FahPblChannel ON MvaFahPblChannel (MvaText);
CREATE INDEX IDX_MC_FahCntctActID ON MvaFahCntctActID (MvaColID);
CREATE INDEX IDX_MT_FahCntctActID ON MvaFahCntctActID (MvaText);
CREATE INDEX IDX_MC_FahCntctCorID ON MvaFahCntctCorID (MvaColID);
CREATE INDEX IDX_MT_FahCntctCorID ON MvaFahCntctCorID (MvaText);
CREATE INDEX IDX_FahPrdID ON FAQHeader (FahPrdID);
CREATE INDEX IDX_MC_FahAttID ON MvaFahAttID (MvaColID);
CREATE INDEX IDX_MT_FahAttID ON MvaFahAttID (MvaText);
CREATE INDEX IDX_MC_FahAttFileName ON MvaFahAttFileName (MvaColID);
CREATE INDEX IDX_MC_FahAudienceID ON MvaFahAudienceID (MvaColID);
CREATE INDEX IDX_MT_FahAudienceID ON MvaFahAudienceID (MvaText);
CREATE INDEX IDX_FahSameAsFah ON FAQHeader (FahSameAsFah);
CREATE INDEX IDX_FahFromFahID ON FAQHeader (FahFromFahID);

-- index for FAQHeaderTagCode
CREATE INDEX IDX_FhtFahID ON FAQHeaderTagCode (FhtFahID);

-- index for FAQLink
CREATE INDEX IDX_FqlFahID1 ON FAQLink (FqlFahID1);
CREATE INDEX IDX_FqlFahID2 ON FAQLink (FqlFahID2);

-- index for Score
CREATE INDEX IDX_ScoFahID ON Score (ScoFahID);
CREATE INDEX IDX_ScoActID ON Score (ScoActID);

-- index for Tag
CREATE INDEX IDX_TagLngID ON Tag (TagLngID);

-- index for Snapshot
CREATE INDEX IDX_SnaCmeID ON Snapshot (SnaCmeID);
CREATE INDEX IDX_MC_SnaParams ON MvaSnaParams (MvaColID);
CREATE INDEX IDX_SnaFreq ON Snapshot (SnaFreq);
CREATE INDEX IDX_SnaTzoID ON Snapshot (SnaTzoID);
CREATE INDEX IDX_SnaLngID ON Snapshot (SnaLngID);
CREATE INDEX IDX_SnaShsID ON Snapshot (SnaShsID);

-- index for SnapshotDisplay
CREATE INDEX IDX_SdiSnaID ON SnapshotDisplay (SdiSnaID);
CREATE INDEX IDX_SdiSdtID ON SnapshotDisplay (SdiSdtID);
CREATE INDEX IDX_SdiGranularity1 ON SnapshotDisplay (SdiGranularity1);
CREATE INDEX IDX_SdiGranularity2 ON SnapshotDisplay (SdiGranularity2);
CREATE INDEX IDX_SdiGranularity3 ON SnapshotDisplay (SdiGranularity3);
CREATE INDEX IDX_SdiGranularity4 ON SnapshotDisplay (SdiGranularity4);
CREATE INDEX IDX_SdiFilter1Type ON SnapshotDisplay (SdiFilter1Type);
CREATE INDEX IDX_MC_SdiFilter1Values ON MvaSdiFilter1Values (MvaColID);
CREATE INDEX IDX_SdiFilter2Type ON SnapshotDisplay (SdiFilter2Type);
CREATE INDEX IDX_MC_SdiFilter2Values ON MvaSdiFilter2Values (MvaColID);
CREATE INDEX IDX_SdiFilter3Type ON SnapshotDisplay (SdiFilter3Type);
CREATE INDEX IDX_MC_SdiFilter3Values ON MvaSdiFilter3Values (MvaColID);
CREATE INDEX IDX_SdiFilter4Type ON SnapshotDisplay (SdiFilter4Type);
CREATE INDEX IDX_MC_SdiFilter4Values ON MvaSdiFilter4Values (MvaColID);
CREATE INDEX IDX_MC_SdiMergedTables ON MvaSdiMergedTables (MvaColID);
CREATE INDEX IDX_MT_SdiMergedTables ON MvaSdiMergedTables (MvaText);
CREATE INDEX IDX_SdiFilter1DfiID ON SnapshotDisplay (SdiFilter1DfiID);
CREATE INDEX IDX_SdiFilter2DfiID ON SnapshotDisplay (SdiFilter2DfiID);
CREATE INDEX IDX_SdiFilter3DfiID ON SnapshotDisplay (SdiFilter3DfiID);
CREATE INDEX IDX_SdiFilter4DfiID ON SnapshotDisplay (SdiFilter4DfiID);
CREATE INDEX IDX_SdiFmtGreenHcoID ON SnapshotDisplay (SdiFmtGreenHcoID);
CREATE INDEX IDX_SdiFmtRedHcoID ON SnapshotDisplay (SdiFmtRedHcoID);
CREATE INDEX IDX_MC_SdiPartitionID ON MvaSdiPartitionID (MvaColID);
CREATE INDEX IDX_MT_SdiPartitionID ON MvaSdiPartitionID (MvaText);

-- index for SnapshotPanel
CREATE INDEX IDX_MC_SpaDisplays ON MvaSpaDisplays (MvaColID);
CREATE INDEX IDX_MT_SpaDisplays ON MvaSpaDisplays (MvaText);

-- index for StatRecords
CREATE INDEX IDX_SreSnaID ON StatRecords (SreSnaID);
CREATE INDEX IDX_SreAxis1Ref ON StatRecords (SreAxis1Ref);
CREATE INDEX IDX_SreAxis2Ref ON StatRecords (SreAxis2Ref);
CREATE INDEX IDX_SreAxis3Ref ON StatRecords (SreAxis3Ref);

-- index for Appetence
CREATE INDEX IDX_AptPerID ON Appetence (AptPerID);
CREATE INDEX IDX_AptSilID ON Appetence (AptSilID);
CREATE INDEX IDX_AptQualification ON Appetence (AptQualification);

-- index for Axis
CREATE INDEX IDX_AxeFldID ON Axis (AxeFldID);

-- index for Campaign
CREATE INDEX IDX_MC_CpgAttID ON MvaCpgAttID (MvaColID);
CREATE INDEX IDX_MT_CpgAttID ON MvaCpgAttID (MvaText);
CREATE INDEX IDX_MC_CpgAttFileName ON MvaCpgAttFileName (MvaColID);
CREATE INDEX IDX_MC_CpgStgID ON MvaCpgStgID (MvaColID);
CREATE INDEX IDX_MT_CpgStgID ON MvaCpgStgID (MvaText);
CREATE INDEX IDX_CpgLevel ON Campaign (CpgLevel);
CREATE INDEX IDX_CpgIndicUnit1 ON Campaign (CpgIndicUnit1);
CREATE INDEX IDX_CpgIndicUnit2 ON Campaign (CpgIndicUnit2);
CREATE INDEX IDX_CpgIndicUnit3 ON Campaign (CpgIndicUnit3);
CREATE INDEX IDX_CpgIndicUnit4 ON Campaign (CpgIndicUnit4);
CREATE INDEX IDX_CpgIndicUnit5 ON Campaign (CpgIndicUnit5);
CREATE INDEX IDX_CpgEnt ON Campaign (CpgEnt);
CREATE INDEX IDX_CpgDept ON Campaign (CpgDept);
CREATE INDEX IDX_CpgYear ON Campaign (CpgYear);

-- index for Categorization
CREATE INDEX IDX_CtnCampID ON Categorization (CtnCampID);
CREATE INDEX IDX_CtnStageID ON Categorization (CtnStageID);
CREATE INDEX IDX_CtnFactLn ON Categorization (CtnFactLn);

-- index for Competitor
CREATE INDEX IDX_CptIplID ON Competitor (CptIplID);
CREATE INDEX IDX_MC_CptRopID ON MvaCptRopID (MvaColID);
CREATE INDEX IDX_MT_CptRopID ON MvaCptRopID (MvaText);
CREATE INDEX IDX_MC_CptAttID ON MvaCptAttID (MvaColID);
CREATE INDEX IDX_MT_CptAttID ON MvaCptAttID (MvaText);
CREATE INDEX IDX_MC_CptAttFileName ON MvaCptAttFileName (MvaColID);

-- index for Contribution
CREATE INDEX IDX_CtbCampID ON Contribution (CtbCampID);
CREATE INDEX IDX_CtbDeptID ON Contribution (CtbDeptID);

-- index for Criteria
CREATE INDEX IDX_CriFobID ON Criteria (CriFobID);
CREATE INDEX IDX_CriFldID ON Criteria (CriFldID);
CREATE INDEX IDX_MC_CriChx ON MvaCriChx (MvaColID);
CREATE INDEX IDX_CriOpe ON Criteria (CriOpe);
CREATE INDEX IDX_CriParentID ON Criteria (CriParentID);

-- index for Criteria2
CREATE INDEX IDX_Cr2Se2ID ON Criteria2 (Cr2Se2ID);
CREATE INDEX IDX_Cr2ParentID ON Criteria2 (Cr2ParentID);
CREATE INDEX IDX_Cr2FobID ON Criteria2 (Cr2FobID);
CREATE INDEX IDX_Cr2FldID ON Criteria2 (Cr2FldID);
CREATE INDEX IDX_Cr2Ope ON Criteria2 (Cr2Ope);
CREATE INDEX IDX_MC_Cr2Chx ON MvaCr2Chx (MvaColID);
CREATE INDEX IDX_Cr2Condition ON Criteria2 (Cr2Condition);
CREATE INDEX IDX_Cr2CardOpe ON Criteria2 (Cr2CardOpe);

-- index for Document
CREATE INDEX IDX_DocObjID ON Document (DocObjID);
CREATE INDEX IDX_DocAttID ON Document (DocAttID);
CREATE INDEX IDX_DocType ON Document (DocType);
CREATE INDEX IDX_DocActID ON Document (DocActID);
CREATE INDEX IDX_MC_DocRolesID ON MvaDocRolesID (MvaColID);
CREATE INDEX IDX_MT_DocRolesID ON MvaDocRolesID (MvaText);
CREATE INDEX IDX_MC_DocDocID ON MvaDocDocID (MvaColID);
CREATE INDEX IDX_MT_DocDocID ON MvaDocDocID (MvaText);
CREATE INDEX IDX_DocCatID ON Document (DocCatID);
CREATE INDEX IDX_DocLngID ON Document (DocLngID);
CREATE INDEX IDX_MC_DocPartitionID ON MvaDocPartitionID (MvaColID);
CREATE INDEX IDX_MT_DocPartitionID ON MvaDocPartitionID (MvaText);

-- index for Editor
CREATE INDEX IDX_EdiCtrID ON Editor (EdiCtrID);

-- index for EditorialPlanning
CREATE INDEX IDX_EdpJou ON EditorialPlanning (EdpJou);
CREATE INDEX IDX_EdpSupID ON EditorialPlanning (EdpSupID);

-- index for Event
CREATE INDEX IDX_EvtCategory ON Event (EvtCategory);
CREATE INDEX IDX_EvtWopID ON Event (EvtWopID);
CREATE INDEX IDX_MC_EvtActors ON MvaEvtActors (MvaColID);
CREATE INDEX IDX_MT_EvtActors ON MvaEvtActors (MvaText);
CREATE INDEX IDX_EvtCtrID ON Event (EvtCtrID);
CREATE INDEX IDX_MC_EvtPartitionID ON MvaEvtPartitionID (MvaColID);
CREATE INDEX IDX_MT_EvtPartitionID ON MvaEvtPartitionID (MvaText);

-- index for ExpenseCategory
CREATE INDEX IDX_ExcCampID ON ExpenseCategory (ExcCampID);
CREATE INDEX IDX_ExcPosteID ON ExpenseCategory (ExcPosteID);

-- index for Form
CREATE INDEX IDX_FrmEventID ON Form (FrmEventID);
CREATE INDEX IDX_FrmResponderObj ON Form (FrmResponderObj);
CREATE INDEX IDX_FrmCategory ON Form (FrmCategory);
CREATE INDEX IDX_FrmEveStChMode ON Form (FrmEveStChMode);
CREATE INDEX IDX_FrmStatus ON Form (FrmStatus);
CREATE INDEX IDX_FrmLngID ON Form (FrmLngID);
CREATE INDEX IDX_FrmParStatus ON Form (FrmParStatus);
CREATE INDEX IDX_FrmParStatusRule ON Form (FrmParStatusRule);

-- index for FormQuestion
CREATE INDEX IDX_FqtCategory ON FormQuestion (FqtCategory);
CREATE INDEX IDX_FqtType ON FormQuestion (FqtType);
CREATE INDEX IDX_FqtRefTable ON FormQuestion (FqtRefTable);
CREATE INDEX IDX_FqtDispType ON FormQuestion (FqtDispType);
CREATE INDEX IDX_FqtStoreInObjID ON FormQuestion (FqtStoreInObjID);
CREATE INDEX IDX_FqtStoreInFldID ON FormQuestion (FqtStoreInFldID);

-- index for FormResponse
CREATE INDEX IDX_FrpFormID ON FormResponse (FrpFormID);
CREATE INDEX IDX_FrpPersonID ON FormResponse (FrpPersonID);
CREATE INDEX IDX_FrpStatus ON FormResponse (FrpStatus);
CREATE INDEX IDX_FrpLastQuestionID ON FormResponse (FrpLastQuestionID);

-- index for FormReturn
CREATE INDEX IDX_FrnFormID ON FormReturn (FrnFormID);

-- index for GuestList
CREATE INDEX IDX_GliActID ON GuestList (GliActID);
CREATE INDEX IDX_MC_GliGuests ON MvaGliGuests (MvaColID);
CREATE INDEX IDX_MT_GliGuests ON MvaGliGuests (MvaText);
CREATE INDEX IDX_GliSguID ON GuestList (GliSguID);
CREATE INDEX IDX_GliEvtID ON GuestList (GliEvtID);

-- index for Invoice
CREATE INDEX IDX_InvSupplID ON Invoice (InvSupplID);
CREATE INDEX IDX_InvPayClass ON Invoice (InvPayClass);
CREATE INDEX IDX_InvEntID ON Invoice (InvEntID);
CREATE INDEX IDX_InvStatus ON Invoice (InvStatus);

-- index for InvoiceEntry
CREATE INDEX IDX_IneSupplId ON InvoiceEntry (IneSupplId);
CREATE INDEX IDX_IneExpId ON InvoiceEntry (IneExpId);

-- index for Journalist
CREATE INDEX IDX_JouCivID ON Journalist (JouCivID);
CREATE INDEX IDX_JouPerCtrID ON Journalist (JouPerCtrID);
CREATE INDEX IDX_JouProCtrID ON Journalist (JouProCtrID);
CREATE INDEX IDX_MC_JouSupID ON MvaJouSupID (MvaColID);
CREATE INDEX IDX_MT_JouSupID ON MvaJouSupID (MvaText);
CREATE INDEX IDX_JouJfuID ON Journalist (JouJfuID);
CREATE INDEX IDX_MC_JouHeaID ON MvaJouHeaID (MvaColID);
CREATE INDEX IDX_MT_JouHeaID ON MvaJouHeaID (MvaText);
CREATE INDEX IDX_MC_JouIntID ON MvaJouIntID (MvaColID);
CREATE INDEX IDX_MT_JouIntID ON MvaJouIntID (MvaText);
CREATE INDEX IDX_MC_JouJevID ON MvaJouJevID (MvaColID);
CREATE INDEX IDX_MT_JouJevID ON MvaJouJevID (MvaText);

-- index for LinkFormQuestion
CREATE INDEX IDX_LfqFormID ON LinkFormQuestion (LfqFormID);
CREATE INDEX IDX_LfqFormQuestionID ON LinkFormQuestion (LfqFormQuestionID);

-- index for LinkScriptElement
CREATE INDEX IDX_LseScriptID ON LinkScriptElement (LseScriptID);
CREATE INDEX IDX_LseScriptElementID ON LinkScriptElement (LseScriptElementID);
CREATE INDEX IDX_LsePageID ON LinkScriptElement (LsePageID);

-- index for LinkScriptElementObjection
CREATE INDEX IDX_LsoScriptElementID ON LinkScriptElementObjection (LsoScriptElementID);
CREATE INDEX IDX_LsoObjectionID ON LinkScriptElementObjection (LsoObjectionID);

-- index for Market
CREATE INDEX IDX_MC_MarKeywordID ON MvaMarKeywordID (MvaColID);
CREATE INDEX IDX_MT_MarKeywordID ON MvaMarKeywordID (MvaText);
CREATE INDEX IDX_MC_MarAttID ON MvaMarAttID (MvaColID);
CREATE INDEX IDX_MT_MarAttID ON MvaMarAttID (MvaText);
CREATE INDEX IDX_MC_MarAttFileName ON MvaMarAttFileName (MvaColID);
CREATE INDEX IDX_MarMcaID ON Market (MarMcaID);

-- index for Materiel
CREATE INDEX IDX_MC_MatAttID ON MvaMatAttID (MvaColID);
CREATE INDEX IDX_MT_MatAttID ON MvaMatAttID (MvaText);
CREATE INDEX IDX_MC_MatAttFileName ON MvaMatAttFileName (MvaColID);

-- index for MeasuringMedia
CREATE INDEX IDX_MemSupID ON MeasuringMedia (MemSupID);
CREATE INDEX IDX_MemCptID ON MeasuringMedia (MemCptID);
CREATE INDEX IDX_MemPagID ON MeasuringMedia (MemPagID);
CREATE INDEX IDX_MemAtyID ON MeasuringMedia (MemAtyID);
CREATE INDEX IDX_MC_MemAttID ON MvaMemAttID (MvaColID);
CREATE INDEX IDX_MT_MemAttID ON MvaMemAttID (MvaText);
CREATE INDEX IDX_MC_MemAttFileName ON MvaMemAttFileName (MvaColID);

-- index for NewsPress
CREATE INDEX IDX_MC_NepAttID ON MvaNepAttID (MvaColID);
CREATE INDEX IDX_MT_NepAttID ON MvaNepAttID (MvaText);
CREATE INDEX IDX_MC_NepAttFileName ON MvaNepAttFileName (MvaColID);

-- index for Note
CREATE INDEX IDX_NotActID ON Note (NotActID);
CREATE INDEX IDX_NotCfiID ON Note (NotCfiID);
CREATE INDEX IDX_MC_NotAttID ON MvaNotAttID (MvaColID);
CREATE INDEX IDX_MT_NotAttID ON MvaNotAttID (MvaText);
CREATE INDEX IDX_MC_NotAttFileName ON MvaNotAttFileName (MvaColID);
CREATE INDEX IDX_NotObjID ON Note (NotObjID);

-- index for ObjectionArgument
CREATE INDEX IDX_ObaLanguage ON ObjectionArgument (ObaLanguage);
CREATE INDEX IDX_ObaMoreRefDoc0 ON ObjectionArgument (ObaMoreRefDoc0);
CREATE INDEX IDX_ObaMoreRefDoc1 ON ObjectionArgument (ObaMoreRefDoc1);
CREATE INDEX IDX_ObaMoreRefDoc2 ON ObjectionArgument (ObaMoreRefDoc2);

-- index for PersonEvent
CREATE INDEX IDX_PvtPersonID ON PersonEvent (PvtPersonID);
CREATE INDEX IDX_PvtEventID ON PersonEvent (PvtEventID);
CREATE INDEX IDX_PvtFrpID ON PersonEvent (PvtFrpID);
CREATE INDEX IDX_PvtSrpID ON PersonEvent (PvtSrpID);
CREATE INDEX IDX_PvtTMK ON PersonEvent (PvtTMK);
CREATE INDEX IDX_PvtActID ON PersonEvent (PvtActID);
CREATE INDEX IDX_PvtInsStatus ON PersonEvent (PvtInsStatus);
CREATE INDEX IDX_PvtParStatus ON PersonEvent (PvtParStatus);
CREATE INDEX IDX_PvtPerInsRep ON PersonEvent (PvtPerInsRep);
CREATE INDEX IDX_PvtPerParRep ON PersonEvent (PvtPerParRep);
CREATE INDEX IDX_PvtPerParAcc ON PersonEvent (PvtPerParAcc);
CREATE INDEX IDX_MC_PvtPartitionID ON MvaPvtPartitionID (MvaColID);
CREATE INDEX IDX_MT_PvtPartitionID ON MvaPvtPartitionID (MvaText);

-- index for Population
CREATE INDEX IDX_PopSelID ON Population (PopSelID);
CREATE INDEX IDX_PopSjoID ON Population (PopSjoID);
CREATE INDEX IDX_PopReqID ON Population (PopReqID);
CREATE INDEX IDX_PopParentPopID ON Population (PopParentPopID);
CREATE INDEX IDX_PopSplitFieldID ON Population (PopSplitFieldID);
CREATE INDEX IDX_PopStatus ON Population (PopStatus);
CREATE INDEX IDX_PopObj1 ON Population (PopObj1);
CREATE INDEX IDX_PopObj2 ON Population (PopObj2);
CREATE INDEX IDX_PopObj3 ON Population (PopObj3);
CREATE INDEX IDX_PopObj4 ON Population (PopObj4);
CREATE INDEX IDX_PopObj5 ON Population (PopObj5);
CREATE INDEX IDX_PopSe2ID ON Population (PopSe2ID);
CREATE INDEX IDX_PopEvtID ON Population (PopEvtID);
CREATE INDEX IDX_PopGenType ON Population (PopGenType);
CREATE INDEX IDX_PopEmlID ON Population (PopEmlID);
CREATE INDEX IDX_PopLstID ON Population (PopLstID);
CREATE INDEX IDX_PopMassEmailingID ON Population (PopMassEmailingID);
CREATE INDEX IDX_MC_PopPartitionID ON MvaPopPartitionID (MvaColID);
CREATE INDEX IDX_MT_PopPartitionID ON MvaPopPartitionID (MvaText);

-- index for PopulationEntry
CREATE INDEX IDX_PpePopID ON PopulationEntry (PpePopID);
CREATE INDEX IDX_PpePerID ON PopulationEntry (PpePerID);
CREATE INDEX IDX_PpeEntID ON PopulationEntry (PpeEntID);
CREATE INDEX IDX_PpeSilID ON PopulationEntry (PpeSilID);
CREATE INDEX IDX_PpeSupID ON PopulationEntry (PpeSupID);
CREATE INDEX IDX_PpeJouID ON PopulationEntry (PpeJouID);
CREATE INDEX IDX_MC_PpePartitionID ON MvaPpePartitionID (MvaColID);
CREATE INDEX IDX_MT_PpePartitionID ON MvaPpePartitionID (MvaText);

-- index for Pricing
CREATE INDEX IDX_PrcParent ON Pricing (PrcParent);

-- index for PricingLine
CREATE INDEX IDX_PrlPricing ON PricingLine (PrlPricing);
CREATE INDEX IDX_PrlPrdID ON PricingLine (PrlPrdID);
CREATE INDEX IDX_PrlRopID ON PricingLine (PrlRopID);
CREATE INDEX IDX_PrlFamilyID ON PricingLine (PrlFamilyID);

-- index for Product
CREATE INDEX IDX_PrdActID ON Product (PrdActID);
CREATE INDEX IDX_PrdRopID ON Product (PrdRopID);
CREATE INDEX IDX_MC_PrdAttID ON MvaPrdAttID (MvaColID);
CREATE INDEX IDX_MT_PrdAttID ON MvaPrdAttID (MvaText);
CREATE INDEX IDX_MC_PrdAttFileName ON MvaPrdAttFileName (MvaColID);
CREATE INDEX IDX_MC_PrdCptID ON MvaPrdCptID (MvaColID);
CREATE INDEX IDX_MT_PrdCptID ON MvaPrdCptID (MvaText);
CREATE INDEX IDX_PrdPkgID ON Product (PrdPkgID);
CREATE INDEX IDX_PrdTvaID ON Product (PrdTvaID);
CREATE INDEX IDX_PrdFamilyID ON Product (PrdFamilyID);
CREATE INDEX IDX_PrdPicID ON Product (PrdPicID);
CREATE INDEX IDX_PrdPdfID ON Product (PrdPdfID);
CREATE INDEX IDX_PrdTypID ON Product (PrdTypID);
CREATE INDEX IDX_PrdTprID ON Product (PrdTprID);
CREATE INDEX IDX_MC_PrdQualification ON MvaPrdQualification (MvaColID);
CREATE INDEX IDX_MT_PrdQualification ON MvaPrdQualification (MvaText);
CREATE INDEX IDX_MC_PrdPartitionID ON MvaPrdPartitionID (MvaColID);
CREATE INDEX IDX_MT_PrdPartitionID ON MvaPrdPartitionID (MvaText);

-- index for ProductFamily
CREATE INDEX IDX_PrfActID ON ProductFamily (PrfActID);
CREATE INDEX IDX_PrfColor ON ProductFamily (PrfColor);
CREATE INDEX IDX_MC_PrfQualification ON MvaPrfQualification (MvaColID);
CREATE INDEX IDX_MT_PrfQualification ON MvaPrfQualification (MvaText);
CREATE INDEX IDX_PrfLngID ON ProductFamily (PrfLngID);

-- index for ProductGroupEntry
CREATE INDEX IDX_PgePrdID ON ProductGroupEntry (PgePrdID);
CREATE INDEX IDX_PgeGrpPrdID ON ProductGroupEntry (PgeGrpPrdID);

-- index for QuestionResponse
CREATE INDEX IDX_QrsLfqID ON QuestionResponse (QrsLfqID);
CREATE INDEX IDX_QrsFrpID ON QuestionResponse (QrsFrpID);
CREATE INDEX IDX_QrsRefValID ON QuestionResponse (QrsRefValID);

-- index for Script
CREATE INDEX IDX_ScrEventID ON Script (ScrEventID);
CREATE INDEX IDX_ScrResponderObj ON Script (ScrResponderObj);
CREATE INDEX IDX_ScrCategory ON Script (ScrCategory);
CREATE INDEX IDX_ScrEveStChMode ON Script (ScrEveStChMode);
CREATE INDEX IDX_ScrJSPPage ON Script (ScrJSPPage);
CREATE INDEX IDX_ScrLanguage ON Script (ScrLanguage);
CREATE INDEX IDX_ScrParStatus ON Script (ScrParStatus);
CREATE INDEX IDX_ScrParStatusRule ON Script (ScrParStatusRule);

-- index for ScriptElement
CREATE INDEX IDX_SceCategory ON ScriptElement (SceCategory);
CREATE INDEX IDX_SceType ON ScriptElement (SceType);
CREATE INDEX IDX_SceRefTable ON ScriptElement (SceRefTable);
CREATE INDEX IDX_SceDispType ON ScriptElement (SceDispType);
CREATE INDEX IDX_SceStoreInObjID ON ScriptElement (SceStoreInObjID);
CREATE INDEX IDX_SceStoreInFldID ON ScriptElement (SceStoreInFldID);
CREATE INDEX IDX_SceLanguage ON ScriptElement (SceLanguage);
CREATE INDEX IDX_SceImage ON ScriptElement (SceImage);
CREATE INDEX IDX_SceJSPPage ON ScriptElement (SceJSPPage);

-- index for ScriptElementResponse
CREATE INDEX IDX_SerLseID ON ScriptElementResponse (SerLseID);
CREATE INDEX IDX_SerSrpID ON ScriptElementResponse (SerSrpID);
CREATE INDEX IDX_SerRefValID ON ScriptElementResponse (SerRefValID);

-- index for ScriptElementTransition
CREATE INDEX IDX_SetLse1ID ON ScriptElementTransition (SetLse1ID);
CREATE INDEX IDX_SetLse2ID ON ScriptElementTransition (SetLse2ID);
CREATE INDEX IDX_SetCriSerID ON ScriptElementTransition (SetCriSerID);
CREATE INDEX IDX_SetCriPerID ON ScriptElementTransition (SetCriPerID);

-- index for ScriptPage
CREATE INDEX IDX_ScpScriptID ON ScriptPage (ScpScriptID);

-- index for ScriptResponse
CREATE INDEX IDX_SrpScriptID ON ScriptResponse (SrpScriptID);
CREATE INDEX IDX_SrpPersonID ON ScriptResponse (SrpPersonID);

-- index for Segment
CREATE INDEX IDX_SegColor ON Segment (SegColor);
CREATE INDEX IDX_SegRefValue ON Segment (SegRefValue);
CREATE INDEX IDX_SegAxeID ON Segment (SegAxeID);

-- index for Selection
CREATE INDEX IDX_SelPopID ON Selection (SelPopID);
CREATE INDEX IDX_SelCriEntID ON Selection (SelCriEntID);
CREATE INDEX IDX_SelCriPerID ON Selection (SelCriPerID);
CREATE INDEX IDX_SelMaxTyp ON Selection (SelMaxTyp);
CREATE INDEX IDX_SelCriEvtID ON Selection (SelCriEvtID);
CREATE INDEX IDX_SelAttID ON Selection (SelAttID);
CREATE INDEX IDX_SelColor ON Selection (SelColor);
CREATE INDEX IDX_SelTarget ON Selection (SelTarget);
CREATE INDEX IDX_MC_SelTargets ON MvaSelTargets (MvaColID);
CREATE INDEX IDX_MT_SelTargets ON MvaSelTargets (MvaText);

-- index for Selection2
CREATE INDEX IDX_Se2Model ON Selection2 (Se2Model);
CREATE INDEX IDX_Se2Cr2ID ON Selection2 (Se2Cr2ID);
CREATE INDEX IDX_Se2Event ON Selection2 (Se2Event);
CREATE INDEX IDX_MC_Se2PartitionID ON MvaSe2PartitionID (MvaColID);
CREATE INDEX IDX_MT_Se2PartitionID ON MvaSe2PartitionID (MvaText);

-- index for SelectionJournalist
CREATE INDEX IDX_SjoCriSupID ON SelectionJournalist (SjoCriSupID);
CREATE INDEX IDX_SjoCriJouID ON SelectionJournalist (SjoCriJouID);
CREATE INDEX IDX_SjoType ON SelectionJournalist (SjoType);

-- index for SelectionModel
CREATE INDEX IDX_SmdObjID ON SelectionModel (SmdObjID);
CREATE INDEX IDX_SmdObj1 ON SelectionModel (SmdObj1);
CREATE INDEX IDX_SmdObj2 ON SelectionModel (SmdObj2);
CREATE INDEX IDX_SmdObj3 ON SelectionModel (SmdObj3);
CREATE INDEX IDX_SmdObj4 ON SelectionModel (SmdObj4);
CREATE INDEX IDX_SmdObj5 ON SelectionModel (SmdObj5);
CREATE INDEX IDX_SmdLstID ON SelectionModel (SmdLstID);
CREATE INDEX IDX_MC_SmdPartitionID ON MvaSmdPartitionID (MvaColID);
CREATE INDEX IDX_MT_SmdPartitionID ON MvaSmdPartitionID (MvaText);
CREATE INDEX IDX_SmdOrigin ON SelectionModel (SmdOrigin);

-- index for Stage
CREATE INDEX IDX_StgCpgID ON Stage (StgCpgID);
CREATE INDEX IDX_StgPopID ON Stage (StgPopID);
CREATE INDEX IDX_MC_StgAttFileName ON MvaStgAttFileName (MvaColID);
CREATE INDEX IDX_MC_StgAttID ON MvaStgAttID (MvaColID);
CREATE INDEX IDX_MT_StgAttID ON MvaStgAttID (MvaText);
CREATE INDEX IDX_StgEvtID ON Stage (StgEvtID);
CREATE INDEX IDX_StgIndicUnit1 ON Stage (StgIndicUnit1);
CREATE INDEX IDX_StgIndicUnit2 ON Stage (StgIndicUnit2);
CREATE INDEX IDX_StgIndicUnit3 ON Stage (StgIndicUnit3);
CREATE INDEX IDX_StgIndicUnit4 ON Stage (StgIndicUnit4);
CREATE INDEX IDX_StgIndicUnit5 ON Stage (StgIndicUnit5);

-- index for Support
CREATE INDEX IDX_SupEdiID ON Support (SupEdiID);
CREATE INDEX IDX_SupCtrID ON Support (SupCtrID);
CREATE INDEX IDX_SupFrqID ON Support (SupFrqID);
CREATE INDEX IDX_SupTarID ON Support (SupTarID);
CREATE INDEX IDX_SupSutID ON Support (SupSutID);
CREATE INDEX IDX_MC_SupAttID ON MvaSupAttID (MvaColID);
CREATE INDEX IDX_MT_SupAttID ON MvaSupAttID (MvaText);
CREATE INDEX IDX_MC_SupAttFileName ON MvaSupAttFileName (MvaColID);
CREATE INDEX IDX_SupPlanID ON Support (SupPlanID);
CREATE INDEX IDX_SupLogoID ON Support (SupLogoID);
CREATE INDEX IDX_MC_SupJevID ON MvaSupJevID (MvaColID);
CREATE INDEX IDX_MT_SupJevID ON MvaSupJevID (MvaText);

-- index for Alert
CREATE INDEX IDX_AlrActID ON Alert (AlrActID);
CREATE INDEX IDX_AlrMsgID ON Alert (AlrMsgID);
CREATE INDEX IDX_AlrStlID ON Alert (AlrStlID);

-- index for EMailing
CREATE INDEX IDX_EmaPopID ON EMailing (EmaPopID);
CREATE INDEX IDX_EmaHtmlMsgID ON EMailing (EmaHtmlMsgID);
CREATE INDEX IDX_EmaStateID ON EMailing (EmaStateID);
CREATE INDEX IDX_EmaSenderID ON EMailing (EmaSenderID);
CREATE INDEX IDX_MC_EmaHtmlCtlGrpID ON MvaEmaHtmlCtlGrpID (MvaColID);
CREATE INDEX IDX_MC_EmaTextCtlGrpID ON MvaEmaTextCtlGrpID (MvaColID);
CREATE INDEX IDX_EmaTextMsgID ON EMailing (EmaTextMsgID);
CREATE INDEX IDX_MC_EmaNltID ON MvaEmaNltID (MvaColID);
CREATE INDEX IDX_MT_EmaNltID ON MvaEmaNltID (MvaText);
CREATE INDEX IDX_EmaPopTypID ON EMailing (EmaPopTypID);
CREATE INDEX IDX_EmaTagName ON EMailing (EmaTagName);
CREATE INDEX IDX_EmaReplyToID ON EMailing (EmaReplyToID);

-- index for EmailingStats
CREATE INDEX IDX_EstEmlStatus ON EmailingStats (EstEmlStatus);
CREATE INDEX IDX_EstEmlID ON EmailingStats (EstEmlID);
CREATE INDEX IDX_EstElnID ON EmailingStats (EstElnID);

-- index for EMailLink
CREATE INDEX IDX_ElnEmlID ON EMailLink (ElnEmlID);
CREATE INDEX IDX_ElnWopID ON EMailLink (ElnWopID);
CREATE INDEX IDX_ElnEvtID ON EMailLink (ElnEvtID);
CREATE INDEX IDX_ElnPopID ON EMailLink (ElnPopID);
CREATE INDEX IDX_ElnInsStatus ON EMailLink (ElnInsStatus);

-- index for EMailMessage
CREATE INDEX IDX_EmmMsgID ON EMailMessage (EmmMsgID);
CREATE INDEX IDX_EmmEmlID ON EMailMessage (EmmEmlID);

-- index for EMailOutServer
CREATE INDEX IDX_EosType ON EMailOutServer (EosType);
CREATE INDEX IDX_EosSmtpProtocol ON EMailOutServer (EosSmtpProtocol);

-- index for EMailSender
CREATE INDEX IDX_EsnType ON EMailSender (EsnType);
CREATE INDEX IDX_EsnStatus ON EMailSender (EsnStatus);
CREATE INDEX IDX_EsnActorID ON EMailSender (EsnActorID);
CREATE INDEX IDX_EsnBounceAccessType ON EMailSender (EsnBounceAccessType);
CREATE INDEX IDX_EsnDefaultServer ON EMailSender (EsnDefaultServer);

-- index for EMailSent
CREATE INDEX IDX_EmsEmaID ON EMailSent (EmsEmaID);
CREATE INDEX IDX_EmsPerID ON EMailSent (EmsPerID);
CREATE INDEX IDX_EmsJouID ON EMailSent (EmsJouID);
CREATE INDEX IDX_EmsSilID ON EMailSent (EmsSilID);
CREATE INDEX IDX_EmsEmlID ON EMailSent (EmsEmlID);
CREATE INDEX IDX_EmsBounceReasons ON EMailSent (EmsBounceReasons);

-- index for EMailSnippet
CREATE INDEX IDX_EmtLanguage ON EMailSnippet (EmtLanguage);

-- index for InBoundLog
CREATE INDEX IDX_IblOriID ON InBoundLog (IblOriID);
CREATE INDEX IDX_IblWopID ON InBoundLog (IblWopID);
CREATE INDEX IDX_IblTimeRange ON InBoundLog (IblTimeRange);
CREATE INDEX IDX_IblPreviousLog ON InBoundLog (IblPreviousLog);
CREATE INDEX IDX_IblElnID ON InBoundLog (IblElnID);
CREATE INDEX IDX_IblCivID ON InBoundLog (IblCivID);
CREATE INDEX IDX_IblPerID ON InBoundLog (IblPerID);
CREATE INDEX IDX_IblSilID ON InBoundLog (IblSilID);
CREATE INDEX IDX_IblEmlID ON InBoundLog (IblEmlID);

-- index for MassEmailing
CREATE INDEX IDX_EmlOwner ON MassEmailing (EmlOwner);
CREATE INDEX IDX_EmlStatus ON MassEmailing (EmlStatus);
CREATE INDEX IDX_EmlType ON MassEmailing (EmlType);
CREATE INDEX IDX_EmlDstSelPer ON MassEmailing (EmlDstSelPer);
CREATE INDEX IDX_EmlDstSelSil ON MassEmailing (EmlDstSelSil);
CREATE INDEX IDX_EmlDstPopPer ON MassEmailing (EmlDstPopPer);
CREATE INDEX IDX_EmlDstPopSil ON MassEmailing (EmlDstPopSil);
CREATE INDEX IDX_EmlDstSubsPer ON MassEmailing (EmlDstSubsPer);
CREATE INDEX IDX_EmlDstSubsSil ON MassEmailing (EmlDstSubsSil);
CREATE INDEX IDX_EmlTypeDst ON MassEmailing (EmlTypeDst);
CREATE INDEX IDX_EmlFltPopPer ON MassEmailing (EmlFltPopPer);
CREATE INDEX IDX_EmlFltPopSil ON MassEmailing (EmlFltPopSil);
CREATE INDEX IDX_EmlFltPopOp ON MassEmailing (EmlFltPopOp);
CREATE INDEX IDX_EmlFltReadEmlID ON MassEmailing (EmlFltReadEmlID);
CREATE INDEX IDX_EmlFltReadMsgOp ON MassEmailing (EmlFltReadMsgOp);
CREATE INDEX IDX_EmlFltLinkEmlID ON MassEmailing (EmlFltLinkEmlID);
CREATE INDEX IDX_EmlFltLinkElnID ON MassEmailing (EmlFltLinkElnID);
CREATE INDEX IDX_EmlFltLinkOp ON MassEmailing (EmlFltLinkOp);
CREATE INDEX IDX_EmlFltSubs ON MassEmailing (EmlFltSubs);
CREATE INDEX IDX_EmlFltSubsOp ON MassEmailing (EmlFltSubsOp);
CREATE INDEX IDX_EmlFltEvtID ON MassEmailing (EmlFltEvtID);
CREATE INDEX IDX_EmlFltEvtOp ON MassEmailing (EmlFltEvtOp);
CREATE INDEX IDX_MC_EmlMsgID ON MvaEmlMsgID (MvaColID);
CREATE INDEX IDX_MT_EmlMsgID ON MvaEmlMsgID (MvaText);
CREATE INDEX IDX_EmlSndEnsID ON MassEmailing (EmlSndEnsID);
CREATE INDEX IDX_EmlSndFldID ON MassEmailing (EmlSndFldID);
CREATE INDEX IDX_EmlSndTestGrp ON MassEmailing (EmlSndTestGrp);
CREATE INDEX IDX_EmlSndEosID ON MassEmailing (EmlSndEosID);
CREATE INDEX IDX_EmlFlwEvtID ON MassEmailing (EmlFlwEvtID);
CREATE INDEX IDX_MC_EmlMailSendField ON MvaEmlMailSendField (MvaColID);
CREATE INDEX IDX_MT_EmlMailSendField ON MvaEmlMailSendField (MvaText);
CREATE INDEX IDX_EmlDstPopTest ON MassEmailing (EmlDstPopTest);
CREATE INDEX IDX_EmlFinalPerPopID ON MassEmailing (EmlFinalPerPopID);
CREATE INDEX IDX_EmlFinalSilPopID ON MassEmailing (EmlFinalSilPopID);

-- index for OutBoundLog
CREATE INDEX IDX_OblOdrID ON OutBoundLog (OblOdrID);
CREATE INDEX IDX_OblOriID ON OutBoundLog (OblOriID);
CREATE INDEX IDX_OblWopID ON OutBoundLog (OblWopID);
CREATE INDEX IDX_OblTimeRange ON OutBoundLog (OblTimeRange);

-- index for Publication
CREATE INDEX IDX_MC_PubAttID ON MvaPubAttID (MvaColID);
CREATE INDEX IDX_MT_PubAttID ON MvaPubAttID (MvaText);
CREATE INDEX IDX_MC_PubAttNames ON MvaPubAttNames (MvaColID);
CREATE INDEX IDX_PubPhotoID ON Publication (PubPhotoID);
CREATE INDEX IDX_PubFilmID ON Publication (PubFilmID);
CREATE INDEX IDX_MC_PubLastPublishErrors ON MvaPubLastPublishErrors (MvaColID);
CREATE INDEX IDX_PubSendStatus ON Publication (PubSendStatus);

-- index for PublicationOutlet
CREATE INDEX IDX_PboOutletType ON PublicationOutlet (PboOutletType);
CREATE INDEX IDX_MC_PboAuthActors ON MvaPboAuthActors (MvaColID);
CREATE INDEX IDX_MT_PboAuthActors ON MvaPboAuthActors (MvaText);
CREATE INDEX IDX_MC_PboAuthRoles ON MvaPboAuthRoles (MvaColID);
CREATE INDEX IDX_MT_PboAuthRoles ON MvaPboAuthRoles (MvaText);

-- index for PublicationStats
CREATE INDEX IDX_PbsPubID ON PublicationStats (PbsPubID);
CREATE INDEX IDX_PbsPboID ON PublicationStats (PbsPboID);
CREATE INDEX IDX_PbsStatus ON PublicationStats (PbsStatus);

-- index for Questions
CREATE INDEX IDX_QueAtyID ON Questions (QueAtyID);
CREATE INDEX IDX_MC_QueAnsID ON MvaQueAnsID (MvaColID);
CREATE INDEX IDX_QuePerFldID ON Questions (QuePerFldID);
CREATE INDEX IDX_QueSilFldID ON Questions (QueSilFldID);
CREATE INDEX IDX_QueTheme ON Questions (QueTheme);

-- index for ReturnedMailModel
CREATE INDEX IDX_MC_RmmMatchSubject ON MvaRmmMatchSubject (MvaColID);
CREATE INDEX IDX_MC_RmmMatchText ON MvaRmmMatchText (MvaColID);
CREATE INDEX IDX_MC_RmmMatchHeaders ON MvaRmmMatchHeaders (MvaColID);
CREATE INDEX IDX_RmmAddrLocation ON ReturnedMailModel (RmmAddrLocation);
CREATE INDEX IDX_MC_RmmAddrHeaders ON MvaRmmAddrHeaders (MvaColID);

-- index for Silhouette
CREATE INDEX IDX_SilCivID ON Silhouette (SilCivID);
CREATE INDEX IDX_MC_SilNltID ON MvaSilNltID (MvaColID);
CREATE INDEX IDX_MT_SilNltID ON MvaSilNltID (MvaText);
CREATE INDEX IDX_SilCtyID ON Silhouette (SilCtyID);
CREATE INDEX IDX_MC_SilQueID ON MvaSilQueID (MvaColID);
CREATE INDEX IDX_MT_SilQueID ON MvaSilQueID (MvaText);
CREATE INDEX IDX_SilOrigin ON Silhouette (SilOrigin);
CREATE INDEX IDX_SilCtrID ON Silhouette (SilCtrID);

-- index for SilhouetteTranslator
CREATE INDEX IDX_StrSilFldID ON SilhouetteTranslator (StrSilFldID);
CREATE INDEX IDX_StrPerFldID ON SilhouetteTranslator (StrPerFldID);
CREATE INDEX IDX_StrEntFldID ON SilhouetteTranslator (StrEntFldID);
CREATE INDEX IDX_StrJouFldID ON SilhouetteTranslator (StrJouFldID);
CREATE INDEX IDX_StrSupFldID ON SilhouetteTranslator (StrSupFldID);

-- index for Alarm
CREATE INDEX IDX_AlmActID ON Alarm (AlmActID);
CREATE INDEX IDX_AlmIntID ON Alarm (AlmIntID);
CREATE INDEX IDX_AlmOppID ON Alarm (AlmOppID);

-- index for Correspondent
CREATE INDEX IDX_CorEntID ON Correspondent (CorEntID);
CREATE INDEX IDX_CorPerID ON Correspondent (CorPerID);
CREATE INDEX IDX_CorSupID ON Correspondent (CorSupID);
CREATE INDEX IDX_CorJouID ON Correspondent (CorJouID);

-- index for Enterprise
CREATE INDEX IDX_EntCtrID ON Enterprise (EntCtrID);
CREATE INDEX IDX_EntPosID ON Enterprise (EntPosID);
CREATE INDEX IDX_EntActID ON Enterprise (EntActID);
CREATE INDEX IDX_EntOriID ON Enterprise (EntOriID);
CREATE INDEX IDX_EntAtvID ON Enterprise (EntAtvID);
CREATE INDEX IDX_EntTyeID ON Enterprise (EntTyeID);
CREATE INDEX IDX_EntRecID ON Enterprise (EntRecID);
CREATE INDEX IDX_MC_EntEveID ON MvaEntEveID (MvaColID);
CREATE INDEX IDX_MT_EntEveID ON MvaEntEveID (MvaText);
CREATE INDEX IDX_MC_EntCusID ON MvaEntCusID (MvaColID);
CREATE INDEX IDX_MT_EntCusID ON MvaEntCusID (MvaText);
CREATE INDEX IDX_EntTzoID ON Enterprise (EntTzoID);
CREATE INDEX IDX_MC_EntAttID ON MvaEntAttID (MvaColID);
CREATE INDEX IDX_MT_EntAttID ON MvaEntAttID (MvaText);
CREATE INDEX IDX_MC_EntAttFileName ON MvaEntAttFileName (MvaColID);
CREATE INDEX IDX_EntPrcID ON Enterprise (EntPrcID);
CREATE INDEX IDX_EntAddressStatus ON Enterprise (EntAddressStatus);
CREATE INDEX IDX_EntParentID ON Enterprise (EntParentID);
CREATE INDEX IDX_EntScMktPress ON Enterprise (EntScMktPress);
CREATE INDEX IDX_EntScoringInvest ON Enterprise (EntScoringInvest);
CREATE INDEX IDX_EntGeoCodeStatusID ON Enterprise (EntGeoCodeStatusID);
CREATE INDEX IDX_EntOrgType ON Enterprise (EntOrgType);
CREATE INDEX IDX_EntAddressType ON Enterprise (EntAddressType);
CREATE INDEX IDX_EntSiteType ON Enterprise (EntSiteType);
CREATE INDEX IDX_MC_EntPartitionID ON MvaEntPartitionID (MvaColID);
CREATE INDEX IDX_MT_EntPartitionID ON MvaEntPartitionID (MvaText);
CREATE INDEX IDX_EntStatus ON Enterprise (EntStatus);
CREATE INDEX IDX_EntSolv ON Enterprise (EntSolv);
CREATE INDEX IDX_EntMobileCreationStateI2 ON Enterprise (EntMobileCreationStateID);

-- index for Expense
CREATE INDEX IDX_ExpExfID ON Expense (ExpExfID);
CREATE INDEX IDX_ExpExtID ON Expense (ExpExtID);
CREATE INDEX IDX_ExpCurID ON Expense (ExpCurID);
CREATE INDEX IDX_ExpPayID ON Expense (ExpPayID);
CREATE INDEX IDX_ExpChaID ON Expense (ExpChaID);
CREATE INDEX IDX_MC_ExpActID ON MvaExpActID (MvaColID);
CREATE INDEX IDX_MT_ExpActID ON MvaExpActID (MvaText);

-- index for ExpenseFile
CREATE INDEX IDX_ExfActID ON ExpenseFile (ExfActID);
CREATE INDEX IDX_ExfEfsID ON ExpenseFile (ExfEfsID);

-- index for ExpenseKM
CREATE INDEX IDX_ExkExfID ON ExpenseKM (ExkExfID);

-- index for ExternalLink
CREATE INDEX IDX_EliEntID ON ExternalLink (EliEntID);
CREATE INDEX IDX_EliPerID ON ExternalLink (EliPerID);
CREATE INDEX IDX_EliMotRec ON ExternalLink (EliMotRec);

-- index for Interaction
CREATE INDEX IDX_MC_IntActID ON MvaIntActID (MvaColID);
CREATE INDEX IDX_MT_IntActID ON MvaIntActID (MvaText);
CREATE INDEX IDX_IntOppID ON Interaction (IntOppID);
CREATE INDEX IDX_MC_IntCorID ON MvaIntCorID (MvaColID);
CREATE INDEX IDX_MT_IntCorID ON MvaIntCorID (MvaText);
CREATE INDEX IDX_IntStiID ON Interaction (IntStiID);
CREATE INDEX IDX_IntMedID ON Interaction (IntMedID);
CREATE INDEX IDX_IntOrigID ON Interaction (IntOrigID);
CREATE INDEX IDX_MC_IntParentOwners ON MvaIntParentOwners (MvaColID);
CREATE INDEX IDX_MT_IntParentOwners ON MvaIntParentOwners (MvaText);
CREATE INDEX IDX_MC_IntAttID ON MvaIntAttID (MvaColID);
CREATE INDEX IDX_MT_IntAttID ON MvaIntAttID (MvaText);
CREATE INDEX IDX_MC_IntAttFileName ON MvaIntAttFileName (MvaColID);
CREATE INDEX IDX_IntMsgID ON Interaction (IntMsgID);
CREATE INDEX IDX_IntAtvID ON Interaction (IntAtvID);
CREATE INDEX IDX_IntParLot ON Interaction (IntParLot);
CREATE INDEX IDX_IntCatID ON Interaction (IntCatID);
CREATE INDEX IDX_IntOpeID ON Interaction (IntOpeID);
CREATE INDEX IDX_IntCpgID ON Interaction (IntCpgID);
CREATE INDEX IDX_IntStgID ON Interaction (IntStgID);
CREATE INDEX IDX_IntEmetteur ON Interaction (IntEmetteur);
CREATE INDEX IDX_IntSimID ON Interaction (IntSimID);
CREATE INDEX IDX_MC_IntRefusedActID ON MvaIntRefusedActID (MvaColID);
CREATE INDEX IDX_MT_IntRefusedActID ON MvaIntRefusedActID (MvaText);
CREATE INDEX IDX_MC_IntPartitionID ON MvaIntPartitionID (MvaColID);
CREATE INDEX IDX_MT_IntPartitionID ON MvaIntPartitionID (MvaText);
CREATE INDEX IDX_IntGeoCodeStatusID ON Interaction (IntGeoCodeStatusID);
CREATE INDEX IDX_IntEveID ON Interaction (IntEveID);
CREATE INDEX IDX_IntPvtID ON Interaction (IntPvtID);
CREATE INDEX IDX_IntRefMsgID ON Interaction (IntRefMsgID);
CREATE INDEX IDX_IntResult ON Interaction (IntResult);
CREATE INDEX IDX_IntDestEntID ON Interaction (IntDestEntID);
CREATE INDEX IDX_IntDestPerID ON Interaction (IntDestPerID);
CREATE INDEX IDX_IntProcessInstanceID ON Interaction (IntProcessInstanceID);
CREATE INDEX IDX_IntParentID ON Interaction (IntParentID);
CREATE INDEX IDX_IntRefDocID ON Interaction (IntRefDocID);
CREATE INDEX IDX_IntPtaID ON Interaction (IntPtaID);
CREATE INDEX IDX_IntSentMailID ON Interaction (IntSentMailID);

-- index for Link
CREATE INDEX IDX_LinTypeA ON Link (LinTypeA);
CREATE INDEX IDX_LinTypeB ON Link (LinTypeB);

-- index for Location
CREATE INDEX IDX_LocEntID ON Location (LocEntID);
CREATE INDEX IDX_LocCtrID ON Location (LocCtrID);
CREATE INDEX IDX_MC_LocParentOwners ON MvaLocParentOwners (MvaColID);
CREATE INDEX IDX_MT_LocParentOwners ON MvaLocParentOwners (MvaText);
CREATE INDEX IDX_MC_LocAttID ON MvaLocAttID (MvaColID);
CREATE INDEX IDX_MT_LocAttID ON MvaLocAttID (MvaText);
CREATE INDEX IDX_MC_LocAttFileName ON MvaLocAttFileName (MvaColID);
CREATE INDEX IDX_LocAddressType ON Location (LocAddressType);
CREATE INDEX IDX_LocSiteType ON Location (LocSiteType);
CREATE INDEX IDX_LocGeoCodeStatusID ON Location (LocGeoCodeStatusID);

-- index for Opportunity
CREATE INDEX IDX_OppActID ON Opportunity (OppActID);
CREATE INDEX IDX_OppEntID ON Opportunity (OppEntID);
CREATE INDEX IDX_OppPerID ON Opportunity (OppPerID);
CREATE INDEX IDX_OppStoID ON Opportunity (OppStoID);
CREATE INDEX IDX_OppOpbID ON Opportunity (OppOpbID);
CREATE INDEX IDX_MC_OppCptID ON MvaOppCptID (MvaColID);
CREATE INDEX IDX_MT_OppCptID ON MvaOppCptID (MvaText);
CREATE INDEX IDX_MC_OppParentOwners ON MvaOppParentOwners (MvaColID);
CREATE INDEX IDX_MT_OppParentOwners ON MvaOppParentOwners (MvaText);
CREATE INDEX IDX_MC_OppAttID ON MvaOppAttID (MvaColID);
CREATE INDEX IDX_MT_OppAttID ON MvaOppAttID (MvaText);
CREATE INDEX IDX_MC_OppAttFileName ON MvaOppAttFileName (MvaColID);
CREATE INDEX IDX_OppStuID ON Opportunity (OppStuID);
CREATE INDEX IDX_OppBizProviderID ON Opportunity (OppBizProviderID);
CREATE INDEX IDX_MC_OppPartitionID ON MvaOppPartitionID (MvaColID);
CREATE INDEX IDX_MT_OppPartitionID ON MvaOppPartitionID (MvaText);

-- index for Person
CREATE INDEX IDX_PerCivID ON Person (PerCivID);
CREATE INDEX IDX_PerEntID ON Person (PerEntID);
CREATE INDEX IDX_PerDepID ON Person (PerDepID);
CREATE INDEX IDX_PerFctID ON Person (PerFctID);
CREATE INDEX IDX_PerRleID ON Person (PerRleID);
CREATE INDEX IDX_PerLocID ON Person (PerLocID);
CREATE INDEX IDX_MC_PerLngID ON MvaPerLngID (MvaColID);
CREATE INDEX IDX_MT_PerLngID ON MvaPerLngID (MvaText);
CREATE INDEX IDX_PerCtyID ON Person (PerCtyID);
CREATE INDEX IDX_MC_PerPevID ON MvaPerPevID (MvaColID);
CREATE INDEX IDX_MT_PerPevID ON MvaPerPevID (MvaText);
CREATE INDEX IDX_PerImpID ON Person (PerImpID);
CREATE INDEX IDX_MC_PerNltID ON MvaPerNltID (MvaColID);
CREATE INDEX IDX_MT_PerNltID ON MvaPerNltID (MvaText);
CREATE INDEX IDX_MC_PerQueID ON MvaPerQueID (MvaColID);
CREATE INDEX IDX_MT_PerQueID ON MvaPerQueID (MvaText);
CREATE INDEX IDX_PerPoeID ON Person (PerPoeID);
CREATE INDEX IDX_MC_PerAttID ON MvaPerAttID (MvaColID);
CREATE INDEX IDX_MT_PerAttID ON MvaPerAttID (MvaText);
CREATE INDEX IDX_MC_PerAttFileName ON MvaPerAttFileName (MvaColID);
CREATE INDEX IDX_MC_PerParentOwners ON MvaPerParentOwners (MvaColID);
CREATE INDEX IDX_MT_PerParentOwners ON MvaPerParentOwners (MvaText);
CREATE INDEX IDX_PerCounselor ON Person (PerCounselor);
CREATE INDEX IDX_PerCtrID ON Person (PerCtrID);
CREATE INDEX IDX_PerScoringY ON Person (PerScoringY);
CREATE INDEX IDX_PerLngPrinc ON Person (PerLngPrinc);
CREATE INDEX IDX_PerScoringX ON Person (PerScoringX);
CREATE INDEX IDX_PerTzoID ON Person (PerTzoID);
CREATE INDEX IDX_PerAddressStatus ON Person (PerAddressStatus);
CREATE INDEX IDX_PerFctTyp ON Person (PerFctTyp);
CREATE INDEX IDX_PerFctParentID ON Person (PerFctParentID);
CREATE INDEX IDX_PerFctAddressType ON Person (PerFctAddressType);
CREATE INDEX IDX_PerFctSiteType ON Person (PerFctSiteType);
CREATE INDEX IDX_PerGeoCodeStatusID ON Person (PerGeoCodeStatusID);
CREATE INDEX IDX_MC_PerPartitionID ON MvaPerPartitionID (MvaColID);
CREATE INDEX IDX_MT_PerPartitionID ON MvaPerPartitionID (MvaText);
CREATE INDEX IDX_PerMobileCreationStateI3 ON Person (PerMobileCreationStateID);

-- index for PersonHistory
CREATE INDEX IDX_PehPerID ON PersonHistory (PehPerID);
CREATE INDEX IDX_PehEntID ON PersonHistory (PehEntID);

-- index for ProductOpportunity
CREATE INDEX IDX_ProOppID ON ProductOpportunity (ProOppID);
CREATE INDEX IDX_ProPrdID ON ProductOpportunity (ProPrdID);
CREATE INDEX IDX_MC_ProPartitionID ON MvaProPartitionID (MvaColID);
CREATE INDEX IDX_MT_ProPartitionID ON MvaProPartitionID (MvaText);

-- index for SalesInvest
CREATE INDEX IDX_SinActID ON SalesInvest (SinActID);
CREATE INDEX IDX_SinIntID ON SalesInvest (SinIntID);
CREATE INDEX IDX_SinPopID ON SalesInvest (SinPopID);
CREATE INDEX IDX_SinEventID ON SalesInvest (SinEventID);
CREATE INDEX IDX_SinOppID ON SalesInvest (SinOppID);
CREATE INDEX IDX_SinPersID ON SalesInvest (SinPersID);
CREATE INDEX IDX_SinEntID ON SalesInvest (SinEntID);
CREATE INDEX IDX_SinJourID ON SalesInvest (SinJourID);
CREATE INDEX IDX_SinSuppID ON SalesInvest (SinSuppID);
CREATE INDEX IDX_SinPersEventID ON SalesInvest (SinPersEventID);

-- index for Simulation
CREATE INDEX IDX_SimCreator ON Simulation (SimCreator);
CREATE INDEX IDX_SimPopulation ON Simulation (SimPopulation);
CREATE INDEX IDX_SimIntAtvID ON Simulation (SimIntAtvID);
CREATE INDEX IDX_SimIntStiID ON Simulation (SimIntStiID);
CREATE INDEX IDX_SimIntCpgID ON Simulation (SimIntCpgID);
CREATE INDEX IDX_SimIntStgID ON Simulation (SimIntStgID);
CREATE INDEX IDX_MC_SimActors ON MvaSimActors (MvaColID);
CREATE INDEX IDX_MT_SimActors ON MvaSimActors (MvaText);
CREATE INDEX IDX_MC_SimRoles ON MvaSimRoles (MvaColID);
CREATE INDEX IDX_MT_SimRoles ON MvaSimRoles (MvaText);
CREATE INDEX IDX_SimPredefined ON Simulation (SimPredefined);

-- index for CusSatisfaction
CREATE INDEX IDX_CsaPerID ON CusSatisfaction (CsaPerID);
CREATE INDEX IDX_CsaEntID ON CusSatisfaction (CsaEntID);
CREATE INDEX IDX_CsaSolID ON CusSatisfaction (CsaSolID);
CREATE INDEX IDX_CsaQuestion ON CusSatisfaction (CsaQuestion);

-- index for SAction
CREATE INDEX IDX_SacSolID ON SAction (SacSolID);
CREATE INDEX IDX_MC_SacActID ON MvaSacActID (MvaColID);
CREATE INDEX IDX_MT_SacActID ON MvaSacActID (MvaText);
CREATE INDEX IDX_SacTypID ON SAction (SacTypID);
CREATE INDEX IDX_SacAdvID ON SAction (SacAdvID);
CREATE INDEX IDX_SacPerID ON SAction (SacPerID);
CREATE INDEX IDX_MC_SacAttID ON MvaSacAttID (MvaColID);
CREATE INDEX IDX_MT_SacAttID ON MvaSacAttID (MvaText);

-- index for Solicitation
CREATE INDEX IDX_SolCatID ON Solicitation (SolCatID);
CREATE INDEX IDX_SolSubCatID ON Solicitation (SolSubCatID);
CREATE INDEX IDX_SolPerID ON Solicitation (SolPerID);
CREATE INDEX IDX_SolSilID ON Solicitation (SolSilID);
CREATE INDEX IDX_SolActID ON Solicitation (SolActID);
CREATE INDEX IDX_SolPtyID ON Solicitation (SolPtyID);
CREATE INDEX IDX_SolClsID ON Solicitation (SolClsID);
CREATE INDEX IDX_SolStsID ON Solicitation (SolStsID);
CREATE INDEX IDX_SolNtfID ON Solicitation (SolNtfID);
CREATE INDEX IDX_SolChnID ON Solicitation (SolChnID);
CREATE INDEX IDX_MC_SolDomID ON MvaSolDomID (MvaColID);
CREATE INDEX IDX_MT_SolDomID ON MvaSolDomID (MvaText);
CREATE INDEX IDX_MC_SolAttID ON MvaSolAttID (MvaColID);
CREATE INDEX IDX_MT_SolAttID ON MvaSolAttID (MvaText);
CREATE INDEX IDX_MC_SolAttFileName ON MvaSolAttFileName (MvaColID);
CREATE INDEX IDX_SolFstActID ON Solicitation (SolFstActID);
CREATE INDEX IDX_SolMsgID ON Solicitation (SolMsgID);
CREATE INDEX IDX_SolSlaID ON Solicitation (SolSlaID);
CREATE INDEX IDX_SolSllID ON Solicitation (SolSllID);
CREATE INDEX IDX_MC_SolPartitionID ON MvaSolPartitionID (MvaColID);
CREATE INDEX IDX_MT_SolPartitionID ON MvaSolPartitionID (MvaText);
CREATE INDEX IDX_SolEntID ON Solicitation (SolEntID);
CREATE INDEX IDX_SolCustomer ON Solicitation (SolCustomer);
CREATE INDEX IDX_SolResolutionType ON Solicitation (SolResolutionType);
CREATE INDEX IDX_SolLastQuestion ON Solicitation (SolLastQuestion);

-- index for WallPost
CREATE INDEX IDX_WptActID ON WallPost (WptActID);

-- index for WallPostObject
CREATE INDEX IDX_WpoPostID ON WallPostObject (WpoPostID);

-- index for WallTarget
CREATE INDEX IDX_WtaActID ON WallTarget (WtaActID);