Tuning the IBM DB2 indexes

Tuning the application platform, reserve, and lease indexes can improve performance.

Overview

These indexes provide significant performance improvements when measured against a broad performance test workload. However, database platform performance gains might vary depending on factors such as application usage, load patterns, hardware sizing, application, and database server configuration. DB2 database administrators must monitor databases for efficient index usage to determine the impact that is produced by applying the recommended indexes. They must also determine more indexes that improve performance based on situational and data composition needs.

The indexes that are listed are not included in the Maximo® Real Estate and Facilities base product unless otherwise stated.

Application platform indexes

Add the following performance tuning indexes to DB2 databases.

CREATE INDEX PERF01_T_TRISPACEALLOCATIONFACT ON T_TRISPACEALLOCATIONFACT
(TRICAPTUREPERIODTXOBJID ASC, TRIFACTALLOCMOVESNU ASC, TRIFACTALLOCWORKERSNU ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
CALL SYSPROC.admin_cmd('reorg table T_TRISPACEALLOCATIONFACT');
CALL SYSPROC.admin_cmd('runstats on table T_TRISPACEALLOCATIONFACT WITH distribution and sampled detailed index PERF01_T_TRISPACEALLOCATIONFACT');
 
CREATE INDEX PERF02_T_TRISPACEALLOCATIONFACT ON T_TRISPACEALLOCATIONFACT
(TRICAPTUREPERIODTXOBJID ASC, TRIDIMWORKPOINTFLAGLI ASC, TRIFACTALLOCAREAIMPNU ASC, TRIFACTALLOCWORKPOINTS ASC, TRIDIMSPACECLASSTXOBJID ASC, TRIDIMLOCATIONTXOBJID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
CALL SYSPROC.admin_cmd('reorg table T_TRISPACEALLOCATIONFACT');
CALL SYSPROC.admin_cmd('runstats on table T_TRISPACEALLOCATIONFACT WITH distribution and sampled detailed index PERF02_T_TRISPACEALLOCATIONFACT');
 
CREATE INDEX PERF01_T_TRIPEOPLE ON T_TRIPEOPLE
(TRIRECORDNAMESY ASC, SPEC_ID DESC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
CALL SYSPROC.admin_cmd('reorg table T_TRIPEOPLE');
CALL SYSPROC.admin_cmd('runstats on table T_TRIPEOPLE WITH distribution and sampled detailed index PERF01_T_TRIPEOPLE');
 
CREATE INDEX PERF01_T_TRICOSTCODE ON T_TRICOSTCODE
(SYS_PROJECTID ASC, TRISTATUSCL ASC, SYS_OBJECTID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
CALL SYSPROC.admin_cmd('reorg table T_TRICOSTCODE');
CALL SYSPROC.admin_cmd('runstats on table T_TRICOSTCODE WITH distribution and sampled detailed index PERF01_T_TRICOSTCODE');
 
CREATE INDEX PERF01_T_TRISPACE ON T_TRISPACE
(TRIPARENTPROPERTYTXOBJID ASC, TRIIDTX ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
CALL SYSPROC.admin_cmd('reorg table T_TRISPACE');
CALL SYSPROC.admin_cmd('runstats on table T_TRISPACE WITH distribution and sampled detailed index PERF01_T_TRISPACE');
     
CREATE UNIQUE INDEX PERF01_T_TRISPACECLASSCURRENT ON T_TRISPACECLASSCURRENT
(SPEC_ID ASC) INCLUDE (TRINAMETX) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
CALL SYSPROC.admin_cmd('reorg table T_TRISPACECLASSCURRENT');
CALL SYSPROC.admin_cmd('runstats on table T_TRISPACECLASSCURRENT WITH distribution and sampled detailed index PERF01_T_TRISPACECLASSCURRENT');
 
CREATE INDEX PERF02_T_TRIPEOPLE ON T_TRIPEOPLE
(SYS_GUIID ASC, UPPER(triLastNameTX) ASC, SYS_OBJECTID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
CALL SYSPROC.admin_cmd('reorg table T_TRIPEOPLE');
CALL SYSPROC.admin_cmd('runstats on table T_TRIPEOPLE WITH distribution and sampled detailed index PERF02_T_TRIPEOPLE');
 
CREATE INDEX PERF01_T_ORGANIZATION ON T_ORGANIZATION
(SYS_GUIID ASC, UPPER(triNameTX) ASC, SYS_OBJECTID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
CALL SYSPROC.admin_cmd('reorg table T_ORGANIZATION');
CALL SYSPROC.admin_cmd('runstats on table T_ORGANIZATION WITH distribution and sampled detailed index PERF01_T_ORGANIZATION');
 
CREATE INDEX PERF03_T_TRIWORKTASK ON T_TRIWORKTASK
(SYS_GUIID ASC, UPPER(triNameTX) ASC, SYS_OBJECTID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
CALL SYSPROC.admin_cmd('reorg table T_TRIWORKTASK');
CALL SYSPROC.admin_cmd('runstats on table T_TRIWORKTASK WITH distribution and sampled detailed index PERF03_T_TRIWORKTASK');

Reserve indexes

In internal performance testing, the following indexes increased performance on DB2. Review, add, and tune the indexes for your implementation of the Reserve index:

CREATE INDEX "PERF01_TRIRESERVATIONINSTANCE" ON "T_TRIRESERVATIONINSTANCE" (triPlannedStartDT,SYS_OBJECTID,SYS_GUIID,SYS_PROJECTID,triStatusCL) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
CALL SYSPROC.admin_cmd('reorg table T_TRIRESERVATIONINSTANCE');
CALL SYSPROC.admin_cmd('runstats on table T_TRIRESERVATIONINSTANCE WITH distribution and sampled detailed index PERF01_TRIRESERVATIONINSTANCE');
 
CREATE INDEX "PERF01_TRIRESERVATIONRESOURCE" ON "T_TRIRESERVATIONRESOURCE" (SPEC_ID,SYS_OBJECTID,triResourceTypeLI,SYS_PROJECTID) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
CALL SYSPROC.admin_cmd('reorg table T_TRIRESERVATIONRESOURCE');
CALL SYSPROC.admin_cmd('runstats on table T_TRIRESERVATIONRESOURCE WITH distribution and sampled detailed index PERF01_TRIRESERVATIONRESOURCE');
 
CREATE INDEX "PERF03_TRIPEOPLE" ON "T_TRIPEOPLE" (SPEC_ID,SYS_OBJECTID) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
CALL SYSPROC.admin_cmd('reorg table T_TRIPEOPLE');
CALL SYSPROC.admin_cmd('runstats on table T_TRIPEOPLE WITH distribution and sampled detailed index PERF03_TRIPEOPLE');
 
CREATE INDEX "PERF01_MYPROFILE" ON "T_MYPROFILE" (SPEC_ID,SYS_OBJECTID,triRecordIdSY) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
CALL SYSPROC.admin_cmd('reorg table T_MYPROFILE');
CALL SYSPROC.admin_cmd('runstats on table T_MYPROFILE WITH distribution and sampled detailed index PERF01_MYPROFILE');
 
CREATE INDEX "PERF01_TRIRESERVATIONDEF" ON "T_TRIRESERVATIONDEFINITION" (SPEC_ID,SYS_OBJECTID,SYS_GUIID,SYS_PROJECTID) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
CALL SYSPROC.admin_cmd('reorg table T_TRIRESERVATIONDEFINITION');
CALL SYSPROC.admin_cmd('runstats on table T_TRIRESERVATIONDEFINITION WITH distribution and sampled detailed index PERF01_TRIRESERVATIONDEF');
 
CREATE INDEX "PERF01_TRIROLE" ON "T_TRIROLE" (SPEC_ID,triNameTX) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
CALL SYSPROC.admin_cmd('reorg table T_TRIROLE');
CALL SYSPROC.admin_cmd('runstats on table T_TRIROLE WITH distribution and sampled detailed index PERF01_TRIROLE');
 
CREATE INDEX "PERF01_TRICONTACTROLE" ON "T_TRICONTACTROLE" (SPEC_ID,SYS_OBJECTID,ClassifiedByRoleSysKey) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
CALL SYSPROC.admin_cmd('reorg table T_TRICONTACTROLE');
CALL SYSPROC.admin_cmd('runstats on table T_TRICONTACTROLE WITH distribution and sampled detailed index PERF01_TRICONTACTROLE');

Lease indexes

Tune any implementation of the Lease Management and Lease Accounting applications to include indexes for performance improvement. The following indexes can increase performance for lease queries. However, review and tune these indexes for your specific implementation.

-- LIST OF RECOMMENDED INDEXES
-- ===========================
CREATE INDEX TRIDATA.PERF1804101535060 ON TRIDATA.T_TRIREALESTATECONTRACT (SYS_PROJECTID ASC, SYS_OBJECTID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE UNIQUE INDEX TRIDATA.PERF1804101535230 ON TRIDATA.T_TRIPAYMENTLINEITEM (SPEC_ID ASC) INCLUDE (TRIACCOUNTINGTYPELI, SYS_GUIID, TRIDUEDA, TRIEXPECTEDEXPENSENU, TRIEXPECTEDAMOUNTNU, TRIEXPECTEDACCRUALNU, TRIPAYMENTTYPECLOBJID, TRIPAYMENTTYPECL, TRISTATUSCLOBJID, TRISTATUSCL, TRICURRENCYUO, SYS_TYPE1, TRIUSERMESSAGEFLAGTX, SYS_OBJECTID) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1804101544190 ON TRIDATA.T_SCHEDULEDEVENTS (SYS_OBJECTID ASC, SPEC_ID DESC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1804101551040 ON TRIDATA.T_SCHEDULEDEVENTS (SYS_OBJECTID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1804201552470 ON TRIDATA.T_SCHEDULEDEVENTS (SYS_OBJECTID ASC, ENDDATETIME ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1804201553110 ON TRIDATA.T_SCHEDULEDEVENTS (EVENTSTATUS ASC, SYS_OBJECTID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1804201629100 ON TRIDATA.T_SCHEDULEDEVENTS (SYS_OBJECTID ASC, STARTDATETIME ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1804221912280 ON TRIDATA.T_TRIPLANNEDSPACE (SYS_PROJECTID ASC, SYS_OBJECTID ASC, SYS_TYPE1 ASC, TRIFORMLABELSY ASC, TRIUSERMESSAGEFLAGTX ASC, TRISTATUSCL ASC, TRINAMETX ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1804221916070 ON TRIDATA.T_TRIPLANNEDFLOOR (SYS_PROJECTID ASC, SYS_OBJECTID ASC, SYS_TYPE1 ASC, TRIFORMLABELSY ASC, TRIUSERMESSAGEFLAGTX ASC, TRISTATUSCL ASC, TRINAMETX ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1804221918070 ON TRIDATA.T_TRISPACE (SYS_TYPE1 ASC, SYS_GUIID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1804221919560 ON TRIDATA.T_TRIFLOOR (SYS_TYPE1 ASC, SYS_GUIID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1804221921350 ON TRIDATA.T_TRIINSTALLATION (SYS_PROJECTID ASC, SYS_OBJECTID ASC, TRICITYTX ASC, TRISTATEPROVTX ASC, TRICOUNTRYTX ASC, SYS_TYPE1 ASC, TRIFORMLABELSY ASC, TRIUSERMESSAGEFLAGTX ASC, TRISTATUSCL ASC, TRINAMETX ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1804221923250 ON TRIDATA.T_TRIBUILDING (SYS_PROJECTID ASC, SYS_OBJECTID ASC, TRICITYTX ASC, TRISTATEPROVTX ASC, TRICOUNTRYTX ASC, SYS_TYPE1 ASC, TRIFORMLABELSY ASC, TRIUSERMESSAGEFLAGTX ASC, TRISTATUSCL ASC, TRINAMETX ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1804221925140 ON TRIDATA.T_TRIVERTICALSHAFT (SYS_PROJECTID ASC, SYS_OBJECTID ASC, SYS_TYPE1 ASC, TRIFORMLABELSY ASC, TRIUSERMESSAGEFLAGTX ASC, TRISTATUSCL ASC, TRINAMETX ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1804221928490 ON TRIDATA.T_TRIPROPERTY (SYS_GUIID ASC, SYS_PROJECTID ASC, SYS_OBJECTID ASC, TRICITYTX ASC, TRISTATEPROVTX ASC, TRICOUNTRYTX ASC, SYS_TYPE1 ASC, TRIFORMLABELSY ASC, TRIUSERMESSAGEFLAGTX ASC, TRISTATUSCL ASC, TRINAMETX ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1804222031340 ON TRIDATA.T_TRIPLANNEDSPACE (SYS_PROJECTID ASC, SYS_OBJECTID ASC, SYS_TYPE1 ASC, TRIPARENTFLOORTX ASC, TRIPARENTBUILDINGTX ASC, TRIFORMLABELSY ASC, TRIUSERMESSAGEFLAGTX ASC, TRISTATUSCLOBJID ASC, TRISTATUSCL ASC, TRINAMETX ASC, TRIIDTX ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1804222035120 ON TRIDATA.T_TRIPLANNEDFLOOR (SYS_PROJECTID ASC, SYS_OBJECTID ASC, SYS_TYPE1 ASC, TRIPARENTFLOORTX ASC, TRIPARENTBUILDINGTX ASC, TRIFORMLABELSY ASC, TRIUSERMESSAGEFLAGTX ASC, TRISTATUSCLOBJID ASC, TRISTATUSCL ASC, TRINAMETX ASC, TRIIDTX ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1804222037150 ON TRIDATA.T_TRISPACE (SYS_TYPE1 ASC, TRISTATUSCL ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1804222038500 ON TRIDATA.T_TRIFLOOR (SYS_PROJECTID ASC, SYS_OBJECTID ASC, SYS_TYPE1 ASC, TRIPARENTPROPERTYTX ASC, TRIPARENTFLOORTX ASC, TRIPARENTBUILDINGTX ASC, TRIFORMLABELSY ASC, TRIUSERMESSAGEFLAGTX ASC, TRISTATUSCLOBJID ASC, TRISTATUSCL ASC, TRINAMETX ASC, TRIIDTX ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1804222040390 ON TRIDATA.T_TRIINSTALLATION (SYS_PROJECTID ASC, SYS_OBJECTID ASC, SYS_TYPE1 ASC, TRIPARENTPROPERTYTX ASC, TRIPARENTFLOORTX ASC, TRIPARENTBUILDINGTX ASC, TRIFORMLABELSY ASC, TRIUSERMESSAGEFLAGTX ASC, TRISTATUSCLOBJID ASC, TRISTATUSCL ASC, TRINAMETX ASC, TRIIDTX ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1804222042280 ON TRIDATA.T_TRIBUILDING (SYS_PROJECTID ASC, SYS_OBJECTID ASC, SYS_TYPE1 ASC, TRIPARENTPROPERTYTX ASC, TRIPARENTFLOORTX ASC, TRIPARENTBUILDINGTX ASC, TRIFORMLABELSY ASC, TRIUSERMESSAGEFLAGTX ASC, TRISTATUSCLOBJID ASC, TRISTATUSCL ASC, TRINAMETX ASC, TRIIDTX ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1804222044170 ON TRIDATA.T_TRIVERTICALSHAFT (SYS_PROJECTID ASC, SYS_OBJECTID ASC, SYS_TYPE1 ASC, TRIPARENTPROPERTYTX ASC, TRIPARENTFLOORTX ASC, TRIPARENTBUILDINGTX ASC, TRIFORMLABELSY ASC, TRIUSERMESSAGEFLAGTX ASC, TRISTATUSCLOBJID ASC, TRISTATUSCL ASC, TRINAMETX ASC, TRIIDTX ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1804222047510 ON TRIDATA.T_TRIPROPERTY (SYS_GUIID ASC, SYS_PROJECTID ASC, SYS_OBJECTID ASC, SYS_TYPE1 ASC, TRIPARENTPROPERTYTX ASC, TRIPARENTFLOORTX ASC, TRIPARENTBUILDINGTX ASC, TRIFORMLABELSY ASC, TRIUSERMESSAGEFLAGTX ASC, TRISTATUSCLOBJID ASC, TRISTATUSCL ASC, TRINAMETX ASC, TRIIDTX ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE UNIQUE INDEX TRIDATA.PERF1804222208420 ON TRIDATA.T_TRILEASECLAUSE (SPEC_ID ASC) INCLUDE (SYS_GUIID, TRICLAUSESECTIONCATEGO, TRICLAUSETYPECL, SYS_OBJECTID, SYS_TYPE1, TRIDESCRIPTIONTX, TRIPAGETX, TRISECTIONTX, TRIGRANTEDINLEASECLOBJID, TRIGRANTEDINLEASECL, TRICLAUSETYPECLOBJID, TRICLAUSESECTIONCATEGOOBJID, TRIUSERMESSAGEFLAGTX) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE UNIQUE INDEX TRIDATA.PERF1804222214470 ON TRIDATA.T_TRILEASECLAUSE (SPEC_ID ASC) INCLUDE (SYS_GUIID, SYS_OBJECTID, SYS_TYPE1, TRIDESCRIPTIONTX, TRIPAGETX, TRISECTIONTX, TRIGRANTEDINLEASECLOBJID, TRIGRANTEDINLEASECL, TRICLAUSETYPECLOBJID, TRICLAUSETYPECL, TRICLAUSESECTIONCATEGOOBJID, TRIUSERMESSAGEFLAGTX, TRICLAUSESECTIONCATEGO) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE UNIQUE INDEX TRIDATA.PERF1804232123170 ON TRIDATA.T_TRIPAYMENTLINEITEM (SPEC_ID ASC) INCLUDE (SYS_PROJECTID, ISPAYMENTFORSYSKEY, SYS_OBJECTID, TRICURRENCYUO, TRIPAYMENTTYPECLOBJID, TRIPAYMENTTYPECL, TRIEXPECTEDAMOUNTNU, TRIACTUALAMOUNTNU, TRISTATUSCLOBJID, TRISTATUSCL, SYS_TYPE1, SYS_GUIID) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE UNIQUE INDEX TRIDATA.PERF1804232356320 ON TRIDATA.T_TRIPAYMENTLINEITEM (SPEC_ID ASC) INCLUDE (SYS_PROJECTID, ISPAYMENTFORSYSKEY, SYS_OBJECTID, TRICURRENCYUO, TRIPAYMENTTYPECLOBJID, TRIPAYMENTTYPECL, TRIEXPECTEDAMOUNTNU, TRIACTUALAMOUNTNU, TRISTATUSCLOBJID, TRISTATUSCL, SYS_TYPE1, SYS_GUIID) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE UNIQUE INDEX TRIDATA.PERF1804232356370 ON TRIDATA.T_TRIREALESTATECONTRACT (SPEC_ID ASC) INCLUDE (TRINAMETX) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX PERF35.PERF_GETPAYMENTS ON PERF35.T_TRIPAYMENTLINEITEM (TRIPROCESSPERIODCL ASC, TRISTATUSCL ASC, TRIACCOUNTINGTYPELI ASC, TRIPAYPROCESSEDMODELI ASC, SYS_GUIID ASC, SYS_OBJECTID ASC, TRIDUEDA ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072214360 ON TRIDATA.T_TRIPLANNEDSPACE (SYS_PROJECTID ASC, SYS_OBJECTID ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC, SYS_TYPE1 ASC, TRIPARENTFLOORTX ASC, TRIPARENTBUILDINGTX ASC, TRIFORMLABELSY ASC, TRIUSERMESSAGEFLAGTX ASC, TRISTATUSCLOBJID ASC, TRISTATUSCL ASC, TRINAMETX ASC, TRIIDTX ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072216250 ON TRIDATA.T_TRILAND (SYS_PROJECTID ASC, SYS_OBJECTID ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC, SYS_TYPE1 ASC, TRIPARENTPROPERTYTX ASC, TRIPARENTFLOORTX ASC, TRIPARENTBUILDINGTX ASC, TRIFORMLABELSY ASC, TRIUSERMESSAGEFLAGTX ASC, TRISTATUSCLOBJID ASC, TRISTATUSCL ASC, TRINAMETX ASC, TRIIDTX ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072218140 ON TRIDATA.T_TRIPLANNEDFLOOR (SYS_PROJECTID ASC, SYS_OBJECTID ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC, SYS_TYPE1 ASC, TRIPARENTFLOORTX ASC, TRIPARENTBUILDINGTX ASC, TRIFORMLABELSY ASC, TRIUSERMESSAGEFLAGTX ASC, TRISTATUSCLOBJID ASC, TRISTATUSCL ASC, TRINAMETX ASC, TRIIDTX ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072221430 ON TRIDATA.T_TRISPACE (SYS_TYPE1 ASC, SYS_PROJECTID ASC, SYS_OBJECTID ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC, TRIPARENTPROPERTYTX ASC, TRIPARENTFLOORTX ASC, TRIPARENTBUILDINGTX ASC, TRIFORMLABELSY ASC, TRIUSERMESSAGEFLAGTX ASC, TRISTATUSCLOBJID ASC, TRISTATUSCL ASC, TRINAMETX ASC, TRIIDTX ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072223320 ON TRIDATA.T_TRIFLOOR (SYS_TYPE1 ASC, SYS_PROJECTID ASC, SYS_OBJECTID ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC, TRIPARENTPROPERTYTX ASC, TRIPARENTFLOORTX ASC, TRIPARENTBUILDINGTX ASC, TRIFORMLABELSY ASC, TRIUSERMESSAGEFLAGTX ASC, TRISTATUSCLOBJID ASC, TRISTATUSCL ASC, TRINAMETX ASC, TRIIDTX ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072223410 ON TRIDATA.T_TRIINSTALLATION (SYS_PROJECTID ASC, SYS_OBJECTID ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC, SYS_TYPE1 ASC, TRIPARENTPROPERTYTX ASC, TRIPARENTFLOORTX ASC, TRIPARENTBUILDINGTX ASC, TRIFORMLABELSY ASC, TRIUSERMESSAGEFLAGTX ASC, TRISTATUSCLOBJID ASC, TRISTATUSCL ASC, TRINAMETX ASC, TRIIDTX ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072227100 ON TRIDATA.T_TRIBUILDING (SYS_TYPE1 ASC, SYS_PROJECTID ASC, SYS_OBJECTID ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC, TRIPARENTPROPERTYTX ASC, TRIPARENTFLOORTX ASC, TRIPARENTBUILDINGTX ASC, TRIFORMLABELSY ASC, TRIUSERMESSAGEFLAGTX ASC, TRISTATUSCLOBJID ASC, TRISTATUSCL ASC, TRINAMETX ASC, TRIIDTX ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072227190 ON TRIDATA.T_TRIVERTICALSHAFT (SYS_PROJECTID ASC, SYS_OBJECTID ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC, SYS_TYPE1 ASC, TRIPARENTPROPERTYTX ASC, TRIPARENTFLOORTX ASC, TRIPARENTBUILDINGTX ASC, TRIFORMLABELSY ASC, TRIUSERMESSAGEFLAGTX ASC, TRISTATUSCLOBJID ASC, TRISTATUSCL ASC, TRINAMETX ASC, TRIIDTX ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072229080 ON TRIDATA.T_TRIPROPERTY (SYS_PROJECTID ASC, SYS_OBJECTID ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC, SYS_TYPE1 ASC, TRIPARENTPROPERTYTX ASC, TRIPARENTFLOORTX ASC, TRIPARENTBUILDINGTX ASC, TRIFORMLABELSY ASC, TRIUSERMESSAGEFLAGTX ASC, TRISTATUSCLOBJID ASC, TRISTATUSCL ASC, TRINAMETX ASC, TRIIDTX ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072230570 ON TRIDATA.T_LOCATION (SYS_PROJECTID ASC, SYS_OBJECTID ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC, SYS_TYPE1 ASC, TRIPARENTPROPERTYTX ASC, TRIPARENTFLOORTX ASC, TRIPARENTBUILDINGTX ASC, TRIFORMLABELSY ASC, TRIUSERMESSAGEFLAGTX ASC, TRISTATUSCLOBJID ASC, TRISTATUSCL ASC, TRINAMETX ASC, TRIIDTX ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072232460 ON TRIDATA.T_TRIPROPOSEDSITE (SYS_PROJECTID ASC, SYS_OBJECTID ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC, SYS_TYPE1 ASC, TRIPARENTPROPERTYTX ASC, TRIPARENTFLOORTX ASC, TRIPARENTBUILDINGTX ASC, TRIFORMLABELSY ASC, TRIUSERMESSAGEFLAGTX ASC, TRISTATUSCLOBJID ASC, TRISTATUSCL ASC, TRINAMETX ASC, TRIIDTX ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072238300 ON TRIDATA.T_TRILAND (SYS_PROJECTID ASC, SYS_OBJECTID ASC, TRICITYTX ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC, TRISTATEPROVTX ASC, TRICOUNTRYTX ASC, SYS_TYPE1 ASC, TRIFORMLABELSY ASC, TRIUSERMESSAGEFLAGTX ASC, TRISTATUSCL ASC, TRINAMETX ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072243510 ON TRIDATA.T_TRISPACE (SYS_TYPE1 ASC, SYS_PROJECTID ASC, SYS_OBJECTID ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC, TRIFORMLABELSY ASC, TRIUSERMESSAGEFLAGTX ASC, TRISTATUSCL ASC, TRINAMETX ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072245400 ON TRIDATA.T_TRIFLOOR (SYS_TYPE1 ASC, SYS_PROJECTID ASC, SYS_OBJECTID ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC, TRIFORMLABELSY ASC, TRIUSERMESSAGEFLAGTX ASC, TRISTATUSCL ASC, TRINAMETX ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072245490 ON TRIDATA.T_TRIINSTALLATION (SYS_PROJECTID ASC, SYS_OBJECTID ASC, TRICITYTX ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC, TRISTATEPROVTX ASC, TRICOUNTRYTX ASC, SYS_TYPE1 ASC, TRIFORMLABELSY ASC, TRIUSERMESSAGEFLAGTX ASC, TRISTATUSCL ASC, TRINAMETX ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072249210 ON TRIDATA.T_TRIBUILDING (SYS_TYPE1 ASC, SYS_PROJECTID ASC, SYS_OBJECTID ASC, TRICITYTX ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC, TRISTATEPROVTX ASC, TRICOUNTRYTX ASC, TRIFORMLABELSY ASC, TRIUSERMESSAGEFLAGTX ASC, TRISTATUSCL ASC, TRINAMETX ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072251210 ON TRIDATA.T_TRIPROPERTY (SYS_PROJECTID ASC, SYS_OBJECTID ASC, TRICITYTX ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC, TRISTATEPROVTX ASC, TRICOUNTRYTX ASC, SYS_TYPE1 ASC, TRIFORMLABELSY ASC, TRIUSERMESSAGEFLAGTX ASC, TRISTATUSCL ASC, TRINAMETX ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072253120 ON TRIDATA.T_LOCATION (SYS_PROJECTID ASC, SYS_OBJECTID ASC, TRICITYTX ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC, TRISTATEPROVTX ASC, TRICOUNTRYTX ASC, SYS_TYPE1 ASC, TRIFORMLABELSY ASC, TRIUSERMESSAGEFLAGTX ASC, TRISTATUSCL ASC, TRINAMETX ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072255030 ON TRIDATA.T_TRIPROPOSEDSITE (SYS_PROJECTID ASC, SYS_OBJECTID ASC, TRICITYTX ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC, TRISTATEPROVTX ASC, TRICOUNTRYTX ASC, SYS_TYPE1 ASC, TRIFORMLABELSY ASC, TRIUSERMESSAGEFLAGTX ASC, TRISTATUSCL ASC, TRINAMETX ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072327310 ON TRIDATA.T_TRIPEOPLE (SYS_GUIID ASC, SYS_OBJECTID ASC, PRIMARYORGANIZATIONSYSKEY ASC, TRITITLETX ASC, TRISTATUSCL ASC, TRIEMAILTX ASC, TRIWORKPHONETX ASC, TRIWORKFAXTX ASC, TRINAMETX ASC, TRIUSERMESSAGEFLAGTX ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC, SYS_TYPE1 ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE UNIQUE INDEX TRIDATA.PERF1806072328180 ON TRIDATA.T_ORGANIZATION (SPEC_ID ASC) INCLUDE (TRIPATHTX) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806080059310 ON TRIDATA.T_TRILEASEABSTRACT (SYS_PROJECTID ASC, TRIEXPIRATIONDA ASC, SYS_OBJECTID ASC, TRISTATUSCL ASC, SYS_GUIID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806080101330 ON TRIDATA.T_TRIREALESTATECONTRACT (SYS_GUIID ASC, SYS_PROJECTID ASC, TRIEXPIRATIONDA ASC, SYS_OBJECTID ASC, TRIEXPIRATIONYEARQUART ASC, TRISTATUSCL ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC, SYS_TYPE1 ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806080101410 ON TRIDATA.T_TRIPURCHASEREQUISITION (SYS_PROJECTID ASC, TRIEXPIRATIONDA ASC, SYS_OBJECTID ASC, TRISTATUSCL ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC, SYS_TYPE1 ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806080103340 ON TRIDATA.T_TRISTANDARDCONTRACT (SYS_PROJECTID ASC, TRIEXPIRATIONDA ASC, SYS_OBJECTID ASC, TRISTATUSCL ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC, SYS_TYPE1 ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806080105280 ON TRIDATA.T_TRIASSETLEASE (SYS_PROJECTID ASC, TRIEXPIRATIONDA ASC, SYS_OBJECTID ASC, TRIEXPIRATIONYEARQUART ASC, TRISTATUSCL ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC, SYS_TYPE1 ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806080107220 ON TRIDATA.T_TRIWARRANTY (SYS_PROJECTID ASC, TRIEXPIRATIONDA ASC, SYS_OBJECTID ASC, TRISTATUSCL ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC, SYS_TYPE1 ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806080111080 ON TRIDATA.T_TRIPURCHASEORDER (SYS_PROJECTID ASC, TRIEXPIRATIONDA ASC, SYS_OBJECTID ASC, TRISTATUSCL ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC, SYS_TYPE1 ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806080113010 ON TRIDATA.T_TRISPACEUSEAGREEMENT (SYS_PROJECTID ASC, TRIEXPIRATIONDA ASC, SYS_OBJECTID ASC, TRISTATUSCL ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC, SYS_TYPE1 ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806080116470 ON TRIDATA.T_TRIPRIMECONTRACTCHANGEORDER (SYS_PROJECTID ASC, TRIEXPIRATIONDA ASC, SYS_OBJECTID ASC, TRISTATUSCL ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC, SYS_TYPE1 ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806080120340 ON TRIDATA.T_TRIPRIMECONTRACT (SYS_PROJECTID ASC, TRIEXPIRATIONDA ASC, SYS_OBJECTID ASC, TRISTATUSCL ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC, SYS_TYPE1 ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806080122280 ON TRIDATA.T_TR_STAND_CONTR_CHAN_ORD (SYS_PROJECTID ASC, TRIEXPIRATIONDA ASC, SYS_OBJECTID ASC, TRISTATUSCL ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC, SYS_TYPE1 ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806080124220 ON TRIDATA.T_TRICONTRACT (SYS_PROJECTID ASC, TRIEXPIRATIONDA ASC, SYS_OBJECTID ASC, TRIEXPIRATIONYEARQUART ASC, TRISTATUSCL ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC, SYS_TYPE1 ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806080126160 ON TRIDATA.T_CSTDEFAULTRETENTION (SYS_PROJECTID ASC, TRIEXPIRATIONDA ASC, SYS_OBJECTID ASC, TRIEXPIRATIONYEARQUART ASC, TRISTATUSCL ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC, SYS_TYPE1 ASC, SYS_GUIID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806080128380 ON TRIDATA.REP_TEMPLATE_HDR (REP_NAME ASC, OBJECT_TEMPLATE_ID ASC, CLASS_TYPE_ID ASC, REP_TEMPLATE_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806080129090 ON TRIDATA.MODULE_ASSOCIATION (ASS_BO_ID ASC, DEPENDENT_FLAG ASC, CASCADE_READ_ONLY ASC, REV_ASSOCIATION_VERB ASC, PROJ_CONTAINMENT_DISABLED ASC, ASSOCIATION_VERB ASC, SOURCE_BO_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806071659590 ON TRIDATA.T_TRIAPPROVAL (TRIRECORDIDSY ASC, SYS_GUIID ASC, TRILINKEDBUSINESSOBJ ASC, TRILINKEDRECORDTX ASC, TRISUBMITTEDBYTX ASC, TRISTATUSCL ASC, SYS_OBJECTID ASC, SPEC_ID ASC, SYS_TYPE1 ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806071724280 ON TRIDATA.T_ORGANIZATION (SYS_GUIID ASC, SYS_OBJECTID ASC, TRIFORMLABELSY ASC, TRIUSERMESSAGEFLAGTX ASC, TRISTATUSCLOBJID ASC, TRISTATUSCL ASC, TRINAMETX ASC, TRIIDTX ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC, SYS_TYPE1 ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806071721520 ON TRIDATA.T_TRICITY (SYS_OBJECTID ASC, TRIPATHSY ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE UNIQUE INDEX TRIDATA.PERF1806071724500 ON TRIDATA.T_ORGANIZATION (SPEC_ID ASC) INCLUDE (SYS_OBJECTID, TRIPATHSY) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE UNIQUE INDEX TRIDATA.PERF1806071945040 ON TRIDATA.T_TRIPAYMENTLINEITEM (SPEC_ID ASC) INCLUDE (TRISUMMARYTYPECL, TRISTATUSCL, TRIACCOUNTINGTYPELI, TRIDUEDA, SYS_OBJECTID, TRICURRENCYUO, SYS_GUIID, SYS_TYPE1, TRIEXPECTEDTOTALNU, TRISTATUSCLOBJID, TRIEXPECTEDAMOUNTNU, TRIPAYMENTTYPECLOBJID, TRIPAYMENTTYPECL) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE UNIQUE INDEX TRIDATA.PERF1806071948000 ON TRIDATA.T_TRIPAYMENTLINEITEM (SPEC_ID ASC) INCLUDE (TRISUMMARYTYPECL, TRISTATUSCL, TRIACCOUNTINGTYPELI, SYS_OBJECTID, TRICURRENCYUO, SYS_GUIID, SYS_TYPE1, TRISTATUSCLOBJID, TRIACTUALAMOUNTNU, TRIPAYMENTTYPECLOBJID, TRIPAYMENTTYPECL) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806071623390 ON TRIDATA.UI_TARGET (PRIMARY_OBJECT_ID ASC, UI_TARGET_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806071623470 ON TRIDATA.NAV_ITEM (UI_TARGET_ID ASC, NAV_ITEM_ID DESC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072038510 ON TRIDATA.T_TRIREALESTATECONTRACT (SYS_GUIID ASC, SYS_PROJECTID ASC, SYS_OBJECTID ASC, TRICONTRACTSTATUSCLOBJID ASC, TRICONTRACTSTATUSCL ASC, TRIAREAUO ASC, TRICOUNTRYTX ASC, TRISTATEPROVTX ASC, TRICITYTX ASC, TRIIMAGEIM ASC, TRICONTRACTRENTABLENU ASC, TRIEXPIRATIONDA ASC, TRINAMETX ASC, TRISTATUSCL ASC, TRIUSERMESSAGEFLAGTX ASC, TRIIDTX ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC, SYS_TYPE1 ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072042370 ON TRIDATA.T_TRIREALESTATECONTRACT (SYS_OBJECTSTATE ASC, SYS_GUIID ASC, SYS_PROJECTID ASC, SYS_OBJECTID ASC, TRICONTRACTSTATUSCLOBJID ASC, TRICONTRACTSTATUSCL ASC, TRIAREAUO ASC, TRICOUNTRYTX ASC, TRISTATEPROVTX ASC, TRICITYTX ASC, TRIIMAGEIM ASC, TRICONTRACTRENTABLENU ASC, TRIEXPIRATIONDA ASC, TRINAMETX ASC, TRIIDTX ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC, SYS_TYPE1 ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072102530 ON TRIDATA.T_TRIREALESTATECONTRACT (SYS_OBJECTSTATE ASC, SYS_GUIID ASC, SYS_PROJECTID ASC, SYS_OBJECTID ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072106180 ON TRIDATA.T_TRIREALESTATECONTRACT (SYS_GUIID ASC, SYS_PROJECTID ASC, SYS_OBJECTID ASC, TRISTATUSCL ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072109460 ON TRIDATA.T_TRIREALESTATECONTRACT (SYS_OBJECTSTATE ASC, SYS_GUIID ASC, SYS_PROJECTID ASC, SYS_OBJECTID ASC, TRINAMETX ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072121060 ON TRIDATA.T_TRIPEOPLE (TRIRECORDNAMETX ASC, SPEC_ID DESC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072126500 ON TRIDATA.T_TRIINVOICE (SYS_PROJECTID ASC, SYS_GUIID ASC, SYS_OBJECTID ASC, TRIDATEDA ASC, TRIUSERMESSAGEFLAGTX ASC, TRISTATUSCLOBJID ASC, TRISTATUSCL ASC, TRINAMETX ASC, TRIIDTX ASC, SYS_GEOGRAPHYNAMEOBJID ASC, SYS_ORGNAMEOBJID ASC, SYS_TYPE1 ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072131470 ON TRIDATA.T_TRILEASEABSTRACT (SYS_TYPE1 ASC, SYS_OBJECTID ASC, TRIBUSINESSOBJECTLABEL2 ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072132150 ON TRIDATA.T_TRIREALESTATECONTRACT (SYS_TYPE1 ASC, SYS_OBJECTID ASC, TRIBUSINESSOBJECTLAB ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072132430 ON TRIDATA.T_TRIPURCHASEREQUISITION (SYS_TYPE1 ASC, SYS_OBJECTID ASC, TRIBUSINESSOBJECTLAB ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072132450 ON TRIDATA.T_TRISTANDARDCONTRACT (SYS_OBJECTID ASC, TRIBUSINESSOBJECTLAB ASC, SYS_TYPE1 ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072133130 ON TRIDATA.T_TRIASSETLEASE (SYS_OBJECTID ASC, TRIBUSINESSOBJECTLAB ASC, SYS_TYPE1 ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072134090 ON TRIDATA.T_TRIBLANKETPURCHASEORDER (SYS_OBJECTID ASC, TRIBUSINESSOBJECTLAB ASC, SYS_TYPE1 ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072135310 ON TRIDATA.T_TRISPACEUSEAGREEMENT (SYS_TYPE1 ASC, SYS_OBJECTID ASC, TRIBUSINESSOBJECTLAB ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072136010 ON TRIDATA.T_TRIPRIMECONTRACTCHANGEORDER (SYS_OBJECTID ASC, TRIBUSINESSOBJECTLAB ASC, SYS_TYPE1 ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072136570 ON TRIDATA.T_TRIPRIMECONTRACT (SYS_OBJECTID ASC, TRIBUSINESSOBJECTLAB ASC, SYS_TYPE1 ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072137530 ON TRIDATA.T_TRICONTRACT (SYS_OBJECTID ASC, TRIBUSINESSOBJECTLAB ASC, SYS_TYPE1 ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072138210 ON TRIDATA.T_CSTDEFAULTRETENTION (SYS_OBJECTID ASC, TRIBUSINESSOBJECTLABEL1 ASC, SYS_TYPE1 ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072130330 ON TRIDATA.T_TRIREINVOICE (SYS_GUIID ASC, SYS_OBJECTID ASC, HASCONTRACTSYSKEY ASC, TRIUSERMESSAGEFLAGTX ASC, TRISTATUSCLOBJID ASC, TRISTATUSCL ASC, TRIIDTX ASC, SYS_TYPE1 ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE UNIQUE INDEX TRIDATA.PERF1806072138490 ON TRIDATA.T_TRIREALESTATECONTRACT (SPEC_ID ASC) INCLUDE (TRINAMETX, TRIIDTX) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE UNIQUE INDEX TRIDATA.PERF1806072141080 ON TRIDATA.T_TRICONTACTROLE (SPEC_ID ASC) INCLUDE (SYS_OBJECTID, TRISTATUSCL) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE UNIQUE INDEX TRIDATA.PERF1806072141250 ON TRIDATA.T_TRISTANDARDCONTRACT (SPEC_ID ASC) INCLUDE (SYS_GUIID, TRIIDTX, TRINAMETX, TRITOORGANIZATIONTXOBJID, TRISTATUSCL, TRISTATUSCLOBJID, TRIPENDINGCHANGESROL, TRICOMMITMENTORIGINA, TRICURRENCYUO, TRITOORGANIZATIONTX, SYS_TYPE1, TRICOMMITMENTCHANGES, SYS_OBJECTID) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806072144040 ON TRIDATA.T_TRIPURCHASEORDER (SYS_GUIID ASC, SYS_OBJECTID ASC, TRICURRENCYUO ASC, SYS_TYPE1 ASC, TRISTATUSCLOBJID ASC, TRILINEITEMTOTALNU ASC, TRIVENDORCOMPANYLOOKOBJID ASC, TRIVENDORCOMPANYLOOK ASC, TRINAMETX ASC, TRIIDTX ASC, SPEC_ID ASC, TRISTATUSCL ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1808180010570 ON TRIDATA.T_TRIJOURNALENTRY (TRISTATUSCL ASC, SYS_OBJECTID ASC, SPEC_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1808180017030 ON TRIDATA.WF_EVENT (AGENT_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1808180017130 ON TRIDATA.WF_EVENT (AGENT_ID ASC, BO_ID DESC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1808180022250 ON TRIDATA.T_TRIJOURNALENTRY (SYS_OBJECTID ASC, SPEC_ID DESC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;

CREATE INDEX TRIDATA.PERF1806112022490 ON TRIDATA.APP_OBJECT_PERMISSION (GROUP_ID ASC, COMPANY_ID ASC, SERVICE_ID ASC, APPLICATION_ID ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
COMMIT WORK;
 
-- RECOMMENDED EXISTING INDEXES
-- ============================
-- RUNSTATS ON TABLE TRIDATA.T_LOCATION FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_LOCATIONGUIID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIBUILDING FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_TRIBUILDINGGUIID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIINSTALLATION FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_TRIINSTAGUIID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRILAND FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_TRILANDGUIID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIPLANNEDFLOOR FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_TRIPLANNGUIID2;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIPLANNEDSPACE FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_TRIPLANNGUIID5;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIPROPOSEDSITE FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_TRIPROPOGUIID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIVERTICALSHAFT FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_TRIVERTIGUIID1;
-- COMMIT WORK;

-- RUNSTATS ON TABLE TRIDATA.IBS_SPEC_ASSIGNMENTS FOR SAMPLED DETAILED INDEX TRIDATA.PK_IBS_SPEC_ASSIGNMENTS;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRILEASECLAUSE FOR SAMPLED DETAILED INDEX TRIDATA.PK_TRILEASECLAUSE;
-- COMMIT WORK;

-- RUNSTATS ON TABLE TRIDATA.IBS_SPEC_ASSIGNMENTS FOR SAMPLED DETAILED INDEX TRIDATA.PK_IBS_SPEC_ASSIGNMENTS;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIPAYMENTLINEITEM FOR SAMPLED DETAILED INDEX TRIDATA.PK_TRIPAYMENTLINEITEM;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIREALESTATECONTRACT FOR SAMPLED DETAILED INDEX TRIDATA.PK_TRIREALESTATECONTRACT;
-- COMMIT WORK;

-- RUNSTATS ON TABLE TRIDATA.IBS_SPEC_ASSIGNMENTS FOR SAMPLED DETAILED INDEX TRIDATA.PK_IBS_SPEC_ASSIGNMENTS;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIPAYMENTLINEITEM FOR SAMPLED DETAILED INDEX TRIDATA.PK_TRIPAYMENTLINEITEM;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIREALESTATECONTRACT FOR SAMPLED DETAILED INDEX TRIDATA.PK_TRIREALESTATECONTRACT;
-- COMMIT WORK;

-- RUNSTATS ON TABLE TRIDATA.T_GEOGRAPHY FOR SAMPLED DETAILED INDEX TRIDATA.PERF_SYS_T_GEOGRAPHYOBJECTID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_LOCATION FOR SAMPLED DETAILED INDEX TRIDATA.PERF_SYS_T_LOCATIONOBJECTID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRILAND FOR SAMPLED DETAILED INDEX TRIDATA.PERF_SYS_T_TRILANDOBJECTID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIPROPOSEDSITE FOR SAMPLED DETAILED INDEX TRIDATA.PERF_SYS_T_TRIPROPOOBJECTID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRISPACE FOR SAMPLED DETAILED INDEX TRIDATA.PERF_SYS_T_TRISPACEOBJECTID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIVERTICALSHAFT FOR SAMPLED DETAILED INDEX TRIDATA.PK_TRIVERTICALSHAFT;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIINSTALLATION FOR SAMPLED DETAILED INDEX TRIDATA.P_TRIINSTALLATION;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIPLANNEDFLOOR FOR SAMPLED DETAILED INDEX TRIDATA.P_TRIPLANNEDFLOOR;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIPLANNEDSPACE FOR SAMPLED DETAILED INDEX TRIDATA.P_TRIPLANNEDSPACE;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIINSTALLATION FOR SAMPLED DETAILED INDEX TRIDATA.PERF_SYS_T_TRIINSTAGUIID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIPLANNEDFLOOR FOR SAMPLED DETAILED INDEX TRIDATA.PERF_SYS_T_TRIPLANNGUIID2;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIPLANNEDSPACE FOR SAMPLED DETAILED INDEX TRIDATA.PERF_SYS_T_TRIPLANNGUIID5;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIVERTICALSHAFT FOR SAMPLED DETAILED INDEX TRIDATA.PERF_SYS_T_TRIVERTIGUIID1;
-- COMMIT WORK;

-- RUNSTATS ON TABLE TRIDATA.T_GEOGRAPHY FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_GEOGRAPHYOBJECTID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIPEOPLE FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_TRIPEOPLEGUIID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIPEOPLE FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_TRIPEOPLEOBJECTID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_ORGANIZATION FOR SAMPLED DETAILED INDEX TRIDATA.PK_ORGANIZATION;
-- COMMIT WORK;

-- RUNSTATS ON TABLE TRIDATA.T_GEOGRAPHY FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_GEOGRAPHYOBJECTID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRICOUNTRY FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_TRICOUNTRYOBJECTID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIINSURANCE FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_TRIINSUROBJECTID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRILEASEABSTRACT FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_TRILEASEOBJECTID3;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIPROCUREMENTCARD FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_TRIPROCUOBJECTID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIPURCHASEORDER FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_TRIPURCHOBJECTID2;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIPURCHASEREQUISITION FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_TRIPURCHOBJECTID3;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRISPACEUSEAGREEMENT FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_TRISPACEOBJECTID26;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRISTANDARDCONTRACT FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_TRISTANDOBJECTID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRISTATE FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_TRISTATEOBJECTID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIWARRANTY FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_TRIWARRANTYOBJECTID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TR_STAND_CONTR_CHAN_ORD FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_TR_STANDOBJECTID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.IBS_SPEC_ASSIGNMENTS FOR SAMPLED DETAILED INDEX TRIDATA.PERF01_IBS_SPEC_ASSIGNMENTS;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.IBS_SPEC_ASSIGNMENTS FOR SAMPLED DETAILED INDEX TRIDATA.PERF_IBS_SPEC_ASSIGNMENTS;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.IBS_SPEC_ASSIGNMENTS FOR SAMPLED DETAILED INDEX TRIDATA.PK_IBS_SPEC_ASSIGNMENTS;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIASSETLEASE FOR SAMPLED DETAILED INDEX TRIDATA.PK_TRIASSETLEASE;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIBLANKETPURCHASEORDER FOR SAMPLED DETAILED INDEX TRIDATA.PK_TRIBLANKETPURCHASEORDER;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRICONTRACT FOR SAMPLED DETAILED INDEX TRIDATA.PK_TRICONTRACT;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIPRIMECONTRACT FOR SAMPLED DETAILED INDEX TRIDATA.PK_TRIPRIMECONTRACT;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIPRIMECONTRACTCHANGEORDER FOR SAMPLED DETAILED INDEX TRIDATA.PK_TRIPRIMECONTRACTCHANGEORDER;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_CSTDEFAULTRETENTION FOR SAMPLED DETAILED INDEX TRIDATA.P_CSTDEFAULTRETENTION;
-- COMMIT WORK;

-- RUNSTATS ON TABLE TRIDATA.T_TRIAPPROVAL FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_TRIAPPROVALGUIID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIAPPROVAL FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_TRIAPPROVALOBJECTID1;
-- COMMIT WORK;

-- RUNSTATS ON TABLE TRIDATA.T_GEOGRAPHY FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_GEOGRAPHYOBJECTID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_ORGANIZATION FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_ORGANIZAOBJECTID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_ORGANIZATION FOR SAMPLED DETAILED INDEX TRIDATA.PK_ORGANIZATION;
-- COMMIT WORK;

-- RUNSTATS ON TABLE TRIDATA.IBS_SPEC_ASSIGNMENTS FOR SAMPLED DETAILED INDEX TRIDATA.PK_IBS_SPEC_ASSIGNMENTS;
-- COMMIT WORK;

-- RUNSTATS ON TABLE TRIDATA.IBS_SPEC_ASSIGNMENTS FOR SAMPLED DETAILED INDEX TRIDATA.PK_IBS_SPEC_ASSIGNMENTS;
-- COMMIT WORK;

-- RUNSTATS ON TABLE TRIDATA.T_GEOGRAPHY FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_GEOGRAPHYOBJECTID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIREALESTATECONTRACT FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_TRIREALEGUIID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIREALESTATECONTRACT FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_TRIREALEOBJECTID1;
-- COMMIT WORK;

-- RUNSTATS ON TABLE TRIDATA.T_GEOGRAPHY FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_GEOGRAPHYOBJECTID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIREALESTATECONTRACT FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_TRIREALEGUIID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIREALESTATECONTRACT FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_TRIREALEOBJECTID1;
-- COMMIT WORK;

-- RUNSTATS ON TABLE TRIDATA.T_GEOGRAPHY FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_GEOGRAPHYOBJECTID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIREALESTATECONTRACT FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_TRIREALEGUIID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIREALESTATECONTRACT FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_TRIREALEOBJECTID1;
-- COMMIT WORK;

-- RUNSTATS ON TABLE TRIDATA.T_GEOGRAPHY FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_GEOGRAPHYOBJECTID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIINVOICE FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_TRIINVOICEGUIID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIINVOICE FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_TRIINVOICEOBJECTID1;
-- COMMIT WORK;

-- RUNSTATS ON TABLE TRIDATA.IBS_SPEC_ASSIGNMENTS FOR SAMPLED DETAILED INDEX TRIDATA.IDX03_IBS_SPEC_ASSIGN;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_CSTDEFAULTRETENTION FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_CSTDEFAUGUIID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIASSETLEASE FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_TRIASSETLEASEGUIID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIBLANKETPURCHASEORDER FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_TRIBLANKOBJECTID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRICONTRACT FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_TRICONTRACTGUIID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIPRIMECONTRACT FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_TRIPRIMEGUIID1;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIPRIMECONTRACTCHANGEORDER FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_TRIPRIMEGUIID2;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.IBS_SPEC_ASSIGNMENTS FOR SAMPLED DETAILED INDEX TRIDATA.PERF_IBS_SPEC_ASSIGNMENTS;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIREALESTATECONTRACT FOR SAMPLED DETAILED INDEX TRIDATA.PK_TRIREALESTATECONTRACT;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIREINVOICE FOR SAMPLED DETAILED INDEX TRIDATA.PK_TRIREINVOICE;
-- COMMIT WORK;

-- RUNSTATS ON TABLE TRIDATA.T_TRICONTACTROLE FOR SAMPLED DETAILED INDEX TRIDATA.PERF01_TRICONTACTROLE;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.IBS_SPEC_ASSIGNMENTS FOR SAMPLED DETAILED INDEX TRIDATA.PK_IBS_SPEC_ASSIGNMENTS;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRISTANDARDCONTRACT FOR SAMPLED DETAILED INDEX TRIDATA.PK_TRISTANDARDCONTRACT;
-- COMMIT WORK;

-- RUNSTATS ON TABLE TRIDATA.IBS_SPEC_ASSIGNMENTS FOR SAMPLED DETAILED INDEX TRIDATA.ASS_CTYP_TMPL_SPID;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRIPURCHASEORDER FOR SAMPLED DETAILED INDEX TRIDATA.IDX_SYS_T_TRIPURCHOBJECTID2;
-- COMMIT WORK;
-- RUNSTATS ON TABLE TRIDATA.T_TRICONTACTROLE FOR SAMPLED DETAILED INDEX TRIDATA.PERF01_TRICONTACTROLE;
-- COMMIT WORK;

-- RUNSTATS ON TABLE TRIDATA.APP_OBJECT_PERMISSION FOR SAMPLED DETAILED INDEX TRIDATA.PK_APP_OBJECT_PERMISSION;
-- COMMIT WORK;