Hi,

I've noticed that indexes in my AX 2012 database get very fragmented very quickly. Is this normal and that I should just defragment them regularly or is there a possible issue here that needs investigated?

Regards

Paul

How quickly does index get fragmented ? How often do you rebuild them. What is page count of the in

I only started working with this database about 3 months ago and have been defragmenting them about once every 3 weeks. In that space of time many indexes have become as high as 98% fragmented.

Here's a snapshot. Apologies for the formatting:

TableName	IndexName	IndexType	avg_fragmentation_in_percent	page_count
INVENTITEMLOCATIONCOUNTINGSTATUS	I_11053INVENTITEMLOCATIONIDX	CLUSTERED INDEX	98.9730423620026	779
DIMENSIONATTRIBUTEVALUECOMBINATIONSTATUS	I_388LEDGERDIMENSIONIDX	CLUSTERED INDEX	98.7654320987654	81
SYSUSERLOG	I_855TYPEUSERDATEIDX	NONCLUSTERED INDEX	98.4126984126984	63
SYSUSERLOG	I_855USERIDX	NONCLUSTERED INDEX	98.2142857142857	56
ACCOUNTINGDISTRIBUTION	I_7452LEDGERDIMENSIONIDX	NONCLUSTERED INDEX	98.2142857142857	112
SYSLASTVALUE	I_65528RECORDTYPE	NONCLUSTERED INDEX	97.9827089337176	347
AG_ESTQUOTEOPTIONS	I_102306ESTQUOTEIDX	NONCLUSTERED INDEX	97.6744186046512	43
AG_SALESINVOICETABLE	I_40085CUSTIDX	NONCLUSTERED INDEX	97.4683544303797	79
COSTSHEETCACHE	I_6107SHEETIDKEYIDX	CLUSTERED INDEX	96.9818913480885	497
SUBLEDGERJOURNALENTRY	I_7458EVENTDATE	NONCLUSTERED INDEX	96.969696969697	33
CUSTINVOICEPACKINGSLIPQUANTITYMATCH	I_7229PACKINGSLIPSOURCEDOCUMENTLINEIDX	NONCLUSTERED INDEX	96.9072164948454	97
PURCHPARMLINE_ASSET	I_2626PARMTABLEREFIDX	NONCLUSTERED INDEX	96.875	32
JMGIPCTRANS	I_3208HCMWORKERIDX	NONCLUSTERED INDEX	96.6666666666667	30
SYSTEMSEQUENCES	I_65516ID	CLUSTERED INDEX	96.2962962962963	27
OLE DB Destination_Error	NULL	HEAP	96.2686567164179	268
SYSCLIENTSESSIONS	I_65500SESSIONID	CLUSTERED INDEX	95.2380952380952	21
ACCOUNTINGDISTRIBUTION	I_7452PARENTDISTRIBUTIONIDX	NONCLUSTERED INDEX	94.8717948717949	117
WMSORDER	I_666INVENTTRANSIDX	NONCLUSTERED INDEX	94.8275862068966	116
ACCOUNTINGDISTRIBUTION	I_7452ACCOUNTINGLEGALENTITYIDX	NONCLUSTERED INDEX	94.7826086956522	115
SYSUTILELEMENTSLOG	I_2268TYPENAMEIDX	CLUSTERED INDEX	94.7368421052632	19
ACCOUNTINGDISTRIBUTION	I_7452SOURCEDOCUMENTLINEIDX	NONCLUSTERED INDEX	94.5945945945946	111
ACCOUNTINGDISTRIBUTION	I_7452REFERENCEDISTRIBUTIONIDX	NONCLUSTERED INDEX	94.2105263157895	190
WMSPICKINGROUTELINK	I_2747ORIGORDERIDX	NONCLUSTERED INDEX	94.1176470588235	17
SUBLEDGERJOURNALACCOUNTENTRY	I_7459LEDGERDIMENSIONIDX	NONCLUSTERED INDEX	93.8775510204082	49
SUBLEDGERJOURNALACCOUNTENTRY	I_7459SUBLEDGERJOURNALACCOUNTENTRY	NONCLUSTERED INDEX	93.5483870967742	93
JMGIPCJOURNALTRANS	I_3207HCMWORKERIDX	NONCLUSTERED INDEX	93.3333333333333	30
AG_ESTQUOTEOPTIONS	NULL	HEAP	93.3333333333333	50
INTRASTAT	I_542DATIDX	NONCLUSTERED INDEX	93.3333333333333	15
SALESPARMLINE	I_361CUSTOMSSHIPPINGBILLNUMBERTABLE_8000	NONCLUSTERED INDEX	93.1508920471727	6614
WMSORDERTRANS	I_716DIMIDX	NONCLUSTERED INDEX	93.0232558139535	129
WMSPICKINGROUTE	I_680RECID	NONCLUSTERED INDEX	92.8571428571429	14
PROJECTACCOUNTINGDISTRIBUTION	I_7129PROJCATEGORYIDX	NONCLUSTERED INDEX	92.8571428571429	14
TAXUNCOMMITTED	I_2757DIMENSIONATTRIBUTEVALUECOMBIN60001	NONCLUSTERED INDEX	92.4050632911392	79
SYSPERSONALIZATION	I_1701PRIMARYIDX	CLUSTERED INDEX	92.3076923076923	13
PROJECTACCOUNTINGDISTRIBUTION	I_7129SMMACTIVITIESIDX	NONCLUSTERED INDEX	92.3076923076923	13
SHIPCARRIERADDRESS	I_3554CUSTLOCATIONIDX	NONCLUSTERED INDEX	92.3076923076923	13
WMSORDERTRANS	I_716TODIMIDX	NONCLUSTERED INDEX	91.8032786885246	122
PROJECTACCOUNTINGDISTRIBUTION	I_7129TAXGROUPHEADINGIDX	NONCLUSTERED INDEX	91.6666666666667	12
PROJECTACCOUNTINGDISTRIBUTION	I_7129PROJTABLEIDX	NONCLUSTERED INDEX	91.6666666666667	12
INTRASTAT	I_542INTRACODEIDX	NONCLUSTERED INDEX	91.6666666666667	12
DIMENSIONATTRIBUTEVALUEGROUPSTATUS	I_529DIMENSIONATTRIBUTEVALUEGROUPIDX	CLUSTERED INDEX	91.6666666666667	12
PROJFUNDINGSOURCE	NULL	HEAP	91.304347826087	141
SUBLEDGERJOURNALENTRY	I_7458FISCALCALENDARPERIODIDX	NONCLUSTERED INDEX	91.304347826087	23
TAXUNCOMMITTED	I_2757OFFSETLEDGERDIMENSIONIDX	NONCLUSTERED INDEX	91.1392405063291	79
PROJECTACCOUNTINGDISTRIBUTION	I_7129PROJITEMTRANSCOSTIDX	NONCLUSTERED INDEX	90.9090909090909	11
PROJECTACCOUNTINGDISTRIBUTION	I_7129SMMACTIVITIESIDX1	NONCLUSTERED INDEX	90.9090909090909	11
PROJECTACCOUNTINGDISTRIBUTION	I_7129PROJLINEPROPERTYIDX	NONCLUSTERED INDEX	90.9090909090909	11
PROJECTACCOUNTINGDISTRIBUTION	I_7129CURRENCYIDX	NONCLUSTERED INDEX	90.9090909090909	11
SUBLEDGERJOURNALENTRY	I_7458ACCOUNTINGEVENT	NONCLUSTERED INDEX	90.9090909090909	22
UNITOFMEASURECONVERSIONCACHE	I_4439CONVERSIONIDX	NONCLUSTERED INDEX	90.9090909090909	11
ACCOUNTINGDISTRIBUTION	I_7452REFERENCEROLESOURCEDOCUMENTLINEIDX	NONCLUSTERED INDEX	90.6382978723404	235
SUBLEDGERJOURNALENTRY	I_7458TRANSFERIDX	NONCLUSTERED INDEX	90.4761904761905	21
SYSCLIENTSESSIONS	I_65500STATUS_CLIENTTYPE_USERID	NONCLUSTERED INDEX	90	10
VENDINVOICEMATCHING	I_3034FK_VENDINVOICEINFOTABLE	NONCLUSTERED INDEX	90	10
SHIPCARRIERADDRESS	I_3554LOCATIONIDX	NONCLUSTERED INDEX	90	10
PROJECTACCOUNTINGDISTRIBUTION	I_7129ACCOUNTINGDISTRIBUTIONIDX	NONCLUSTERED INDEX	90	10
WMSPICKINGROUTE	I_680SHIPMENTIDX	NONCLUSTERED INDEX	90	10
INTRASTAT	I_542TRANSRELIDX	NONCLUSTERED INDEX	90	10
SALESPARMLINE	I_361PARMLINERECITEMIDX	NONCLUSTERED INDEX	89.1841354197421	10161
TAXUNCOMMITTED	I_2757TAXUNCOMMITTEDBYTRANSACTIONLINE	NONCLUSTERED INDEX	89.1666666666667	120
DIMENSIONATTRIBUTEVALUEGROUPSTATUS	I_529RECID	NONCLUSTERED INDEX	88.8888888888889	9
SOURCEDOCUMENTLINERELIEVINGAMOUNT	I_101279RECID	CLUSTERED INDEX	88.8888888888889	9
SOURCEDOCUMENTLINERELIEVING	I_101278SOURCEDOCUMENTLINEIDX1	NONCLUSTERED INDEX	88.8888888888889	9
AG_PRECASTDELEMAIL	I_102316RECID	CLUSTERED INDEX	88.8888888888889	9
WMSSHIPMENT	I_682STATUSIDX	NONCLUSTERED INDEX	88.8888888888889	9
WMSSHIPMENT	I_682WMSSHIPMENTTEMPLATEIDX	NONCLUSTERED INDEX	88.8888888888889	9
REQTRANS	I_161ITEMIDX	NONCLUSTERED INDEX	88.8888888888889	9
VENDINVOICEINFOLINE_ASSET	I_2627PARMTABLEREFIDX	NONCLUSTERED INDEX	88.8888888888889	18
ACCOUNTINGDISTRIBUTION	I_7452ACCOUNTINGDISTRIBUTIONAKIDX	CLUSTERED INDEX	88.7201735357918	461
VENDINVOICEINFOSUBLINE	I_1462JOURNALIDX	NONCLUSTERED INDEX	88.2352941176471	17
PRODPARMUPDATE	I_100805PARMIDIDX	CLUSTERED INDEX	87.5	8
HCMEMERGENCYCONTACTRELATIONSHIP	I_9951EMERGENCYCONTACTRELATIONSHIP_AK1	CLUSTERED INDEX	87.5	8
INTRASTAT	I_542TRANSNUMIDX	NONCLUSTERED INDEX	87.5	8
CUSTINVOICEBACKORDERLINE	I_1570RECID	CLUSTERED INDEX	87.5	8
NUMBERSEQUENCEREFERENCE	I_707NUMSEQIDX	NONCLUSTERED INDEX	87.5	8
INVENTTRANSFERPARMUPDATE	I_2526PARMIDIDX	CLUSTERED INDEX	87.5	8
SYSSETUPLOG	I_1518TIMEIDX	NONCLUSTERED INDEX	87.5	8
USERDATAAREAFILTER	I_65482DATAAREAIDX	CLUSTERED INDEX	87.5	8
AG_PICKLISTHEADER	I_102320RECID	CLUSTERED INDEX	87.5	32
SECURITYUSERROLE	I_65492USERROLEIDX	CLUSTERED INDEX	87.5	16
XREFNAMES	I_513NAME	NONCLUSTERED INDEX	87.0967741935484	31
VENDINVOICEINFOSUBLINE	I_1462RECID	NONCLUSTERED INDEX	86.9565217391304	23
ACCOUNTINGDISTRIBUTION	I_7452FINALIZEACCOUNTINGEVENT	NONCLUSTERED INDEX	86.7768595041322	121
WMSPICKINGROUTE	I_680PARMIDX	NONCLUSTERED INDEX	86.6666666666667	15
ACCOUNTINGDISTRIBUTION	I_7452SOURCEDOCUMENTHEADERIDX	NONCLUSTERED INDEX	86.6197183098592	142
AG_SALESINVOICETABLE	NULL	HEAP	86.3636363636364	140
VENDPACKINGSLIPTRANS_INTRASTAT	I_101549VENDPAKINGSLIPTRANS	CLUSTERED INDEX	86.2068965517241	29
SYSDATABASELOG	I_943RECID	NONCLUSTERED INDEX	85.9060402684564	149
LEDGERCURRENCYPARAMETERS_RU	I_9586RTAX25PROFITTABLEPROFITEMPLIDX	NONCLUSTERED INDEX	85.7142857142857	7
LEDGERCURRENCYPARAMETERS_RU	I_9586RTAX25PROFITTABLELOSSEMPLIDX	NONCLUSTERED INDEX	85.7142857142857	7
LEDGERCURRENCYPARAMETERS_RU	I_9586RECID	NONCLUSTERED INDEX	85.7142857142857	7
LEDGERCURRENCYPARAMETERS_RU	I_9586TAXAMOUNTDIFFPROFITLEDGERDIMEN8018	NONCLUSTERED INDEX	85.7142857142857	7
LEDGERCURRENCYPARAMETERS_RU	I_9586TAXAMOUNTDIFFLOSSLEDGERDIMENSI8019	NONCLUSTERED INDEX	85.7142857142857	7
LEDGERCURRENCYPARAMETERS_RU	I_9586TAXAMOUNTDIFFLEDGERDIMENSIONIDX	NONCLUSTERED INDEX	85.7142857142857	7
LEDGERCURRENCYPARAMETERS_RU	I_9586RTAX25PROFITTABLELOSSCUSTIDX	NONCLUSTERED INDEX	85.7142857142857	7
LEDGERCURRENCYPARAMETERS_RU	I_9586RTAX25PROFITTABLELOSSVENDIDX	NONCLUSTERED INDEX	85.7142857142857	7
LEDGERCURRENCYPARAMETERS_RU	I_9586RTAX25PROFITTABLEPROFITIDX	NONCLUSTERED INDEX	85.7142857142857	7
LEDGERCURRENCYPARAMETERS_RU	I_9586RTAX25PROFITTABLEPROFITCUSTPRE8026	NONCLUSTERED INDEX	85.7142857142857	7
LEDGERCURRENCYPARAMETERS_RU	I_9586RTAX25PROFITTABLELOSSCUSTPREPA8027	NONCLUSTERED INDEX	85.7142857142857	7
LEDGERCURRENCYPARAMETERS_RU	I_9586RTAX25PROFITTABLEPROFITVENDPRE8028	NONCLUSTERED INDEX	85.7142857142857	7
LEDGERCURRENCYPARAMETERS_RU	I_9586RTAX25PROFITTABLELOSSVENDPREPA8029	NONCLUSTERED INDEX	85.7142857142857	7
LEDGERCURRENCYPARAMETERS_RU	I_9586REALIZEDPROFITEMPLLEDGERDIMEN60002	NONCLUSTERED INDEX	85.7142857142857	7
LEDGERCURRENCYPARAMETERS_RU	I_9586REALIZEDLOSSEMPLLEDGERDIMENSIONIDX	NONCLUSTERED INDEX	85.7142857142857	7
PSACUSTOMERINVOICERETAIN	I_100852RECID	CLUSTERED INDEX	85.7142857142857	7
LEDGERCURRENCYPARAMETERS_RU	I_9586RTAX25PROFITTABLELOSSIDX	NONCLUSTERED INDEX	85.7142857142857	7
LEDGERCURRENCYPARAMETERS_RU	I_9586UNREALIZEDPROFITTAXCUSTLEDGERD8004	NONCLUSTERED INDEX	85.7142857142857	7
LEDGERCURRENCYPARAMETERS_RU	I_9586UNREALIZEDLOSSTAXCUSTLEDGERDIM8005	NONCLUSTERED INDEX	85.7142857142857	7
LEDGERCURRENCYPARAMETERS_RU	I_9586REALIZEDPROFITTAXCUSTLEDGERDIM8006	NONCLUSTERED INDEX	85.7142857142857	7
LEDGERCURRENCYPARAMETERS_RU	I_9586REALIZEDLOSSTAXCUSTLEDGERDIMEN8007	NONCLUSTERED INDEX	85.7142857142857	7
LEDGERCURRENCYPARAMETERS_RU	I_9586REALIZEDPROFITVENDLEDGERDIMENS8010	NONCLUSTERED INDEX	85.7142857142857	7
LEDGERCURRENCYPARAMETERS_RU	I_9586REALIZEDLOSSVENDLEDGERDIMENSIONIDX	NONCLUSTERED INDEX	85.7142857142857	7
LEDGERCURRENCYPARAMETERS_RU	I_9586UNREALIZEDLOSSVENDLEDGERDIMENS8012	NONCLUSTERED INDEX	85.7142857142857	7
LEDGERCURRENCYPARAMETERS_RU	I_9586UNREALIZEDPROFITVENDLEDGERDIME8013	NONCLUSTERED INDEX	85.7142857142857	7
LEDGERCURRENCYPARAMETERS_RU	I_9586REALIZEDLOSSCUSTLEDGERDIMENSIONIDX	NONCLUSTERED INDEX	85.7142857142857	7
LEDGERCURRENCYPARAMETERS_RU	I_9586REALIZEDPROFITCUSTLEDGERDIMENS8015	NONCLUSTERED INDEX	85.7142857142857	7
DIRNAMESEQUENCETRANSLATION	I_4410DIRNAMESEQUENCELANGUAGEIDX	CLUSTERED INDEX	85.7142857142857	7
INVENTTRANSFERPARMTABLE	I_1707PARTYAGREEMENTHEADEREXT_RUIDX	NONCLUSTERED INDEX	85.7142857142857	7
WORKCALENDAREMPLOYMENT	I_7295RECID	CLUSTERED INDEX	85.7142857142857	7
HCMPERSONALCONTACTRELATIONSHIP	I_10664RECID	NONCLUSTERED INDEX	85.7142857142857	7
RELEASEUPDATESPECIALFIELDMAPPING	I_3319FIELDMAPPINGIDX	NONCLUSTERED INDEX	85.7142857142857	7
REQTRANS	NULL	HEAP	85.7142857142857	8
DEL_SYSCOMPANYUSERINFO	I_1124EMPLIDIDX	NONCLUSTERED INDEX	85.7142857142857	7
HCMEMPLOYMENTDETAIL	I_9706HCMEMPLOYMENTDETAIL_AK1	NONCLUSTERED INDEX	85.7142857142857	7
SYSUTILELEMENTSLOG	I_2268RECID	NONCLUSTERED INDEX	85.7142857142857	7
SMMAXAPTAOUTLOOKMAPPING	I_1943MAPPINGTYPEIDX	CLUSTERED INDEX	85.7142857142857	7
VENDINVOICEPACKINGSLIPQUANTITYMATCH	I_7311PACKINGSLIPINVOICESOURCEDOCUM60001	NONCLUSTERED INDEX	85.7142857142857	14
VENDPACKINGSLIPTRANSHISTORY	I_6545RECID	CLUSTERED INDEX	85.7142857142857	7
VENDINVOICEMATCHING	I_3034FK_PURCHPARMTABLE	NONCLUSTERED INDEX	85.7142857142857	7
NUMBERSEQUENCESCOPE	I_4224NATURALKEY	NONCLUSTERED INDEX	85.7142857142857	7
VENDINVOICEINFOLINE_PROJECT	I_2730VENDINVOICEINFOLINEREFRECIDIDX	NONCLUSTERED INDEX	85.7142857142857	7
RETAILCUSTTABLE	I_17269ACCOUNTIDX	CLUSTERED INDEX	85.7142857142857	7
ASSETLEDGERACCOUNTS	I_1141PROFILEACCOUNTIDX	CLUSTERED INDEX	85.7142857142857	7
EPCHEQUE_HEAD	NULL	HEAP	85.7142857142857	7
SUBLEDGERJOURNALENTRY	I_7458JOURNALNUMBERIDX	NONCLUSTERED INDEX	84.8484848484848	33
SHIPCARRIERADDRESS	I_3554RECID	CLUSTERED INDEX	84.6153846153846	13
USERDATAAREAFILTER	I_65482RECIDIDX	NONCLUSTERED INDEX	84.6153846153846	39
PURCHPARMLINE_ASSET	I_2626RECID	NONCLUSTERED INDEX	84	25
SOURCEDOCUMENTLINERELIEVING	I_101278SOURCEDOCUMENTLINEIDX	NONCLUSTERED INDEX	83.3333333333333	6
PURCHPARMLINE_ASSET	I_2626PURCHPARMLINERECIDIDX	CLUSTERED INDEX	83.3333333333333	42
AG_CAPACITYBREAKDOWN	NULL	HEAP	83.3333333333333	9
HCMEMERGENCYCONTACTRELATIONSHIP	I_9951RECID	NONCLUSTERED INDEX	83.3333333333333	6
INTRASTAT	I_542CATEGORYIDX	NONCLUSTERED INDEX	83.3333333333333	6
HCMJOB	I_4497JOBIDX	NONCLUSTERED INDEX	83.3333333333333	6
XREFNAMES	I_513KEY	NONCLUSTERED INDEX	83.3333333333333	36
AGREEMENTLINE	I_4896RECID	CLUSTERED INDEX	83.3333333333333	6
AG_CAPACITYPLANNER	NULL	HEAP	83.3333333333333	9
EPTMPCASHRECEIPT	I_30048IDX	NONCLUSTERED INDEX	83.3333333333333	6
AG_ESTINCLUSIONS	NULL	HEAP	83.3333333333333	6
LEDGERTRANSVOUCHERLINK	I_6100RECID	NONCLUSTERED INDEX	83.3333333333333	6
NUMBERSEQUENCETABLE_CN	I_100602RECID	CLUSTERED INDEX	83.3333333333333	6
HRMCOURSEATTENDEE	I_8012PERSONREGISTRATIONDATEIDX	NONCLUSTERED INDEX	83.3333333333333	6
AG_POSTCODEADDRESSTABLE	NULL	HEAP	83.3333333333333	11
WMSPICKINGROUTELINK	I_2747PICKINGROUTEIDX	NONCLUSTERED INDEX	83.3333333333333	12
PSAPROJWORKCOMPLETE	I_100882PROJTABLEIDX	NONCLUSTERED INDEX	83.3333333333333	6
VENDTRANSOPEN	I_866FK_DIMENSIONATTRIBUTEVALUECOMBINAT4	NONCLUSTERED INDEX	82.4561403508772	57
VENDTRANSOPEN	I_866BANKLCIMPORTLINEIDX	NONCLUSTERED INDEX	82.4561403508772	57
INVENTITEMGROUPFORM	I_10135LEDGERDIMENSION	CLUSTERED INDEX	82.3529411764706	34
SYSUSERINFO	I_956USERIDX	CLUSTERED INDEX	81.8181818181818	11
LEDGERTRANSVOUCHERLINK	I_6100VOUCHERGROUPIDIDX	CLUSTERED INDEX	81.8181818181818	11
PROJECTACCOUNTINGDISTRIBUTION	I_7129TAXITEMGROUPHEADINGIDX	NONCLUSTERED INDEX	81.8181818181818	11
VENDTRANSOPEN	I_866ACCOUNTDATEIDX	CLUSTERED INDEX	81.453634085213	399
JMGPAYADDTRANS	I_8183EMPLDATEIDIDX	CLUSTERED INDEX	81.2865497076023	342
WMSPICKINGROUTE	I_680LOGISTICSPOSTALADDRESSIDX	NONCLUSTERED INDEX	81.25	16
WMSORDERTRANS	I_716ITEMSTATUSIDX	NONCLUSTERED INDEX	80.2083333333333	96
PRINTMGMTDOCINSTANCE	I_1600PRINTMGMTDOCINSTANCEIDX	CLUSTERED INDEX	80	5
ECORESRELEASEPRODUCTLEGALENTITYLOG	I_7052ECORESRELEASEPRODUCTLEGALENTITYIDX	CLUSTERED INDEX	80	5
RELEASEUPDATESPECIALFIELDMAPPING	I_3319RECID	CLUSTERED INDEX	80	5
REQTRANS	I_161PLANVERSIONREFIDX	NONCLUSTERED INDEX	80	5
REQTRANS	I_161OPENIDX	NONCLUSTERED INDEX	80	5
SYSSETUPLOG	I_1518RECID	NONCLUSTERED INDEX	80	5
HCMPOSITION	I_6202POSITIONIDX	NONCLUSTERED INDEX	80	5
HCMPERSONDETAILS	I_5261HCMPERSONDETAILS_AK1	NONCLUSTERED INDEX	80	10
RELEASEUPDATEBULKCOPYFIELDERRORS	I_100996RELEASEUPDATEBULKCOPYFIELDIDX	NONCLUSTERED INDEX	80	5
AGREEMENTLINERELEASEDLINE	I_5188RECID	CLUSTERED INDEX	80	5
SOURCEDOCUMENTLINERELIEVINGAMOUNT	I_101279SOURCEDOCUMENTLINERELIEVINGAMOU1	NONCLUSTERED INDEX	80	5
ASSETDISPOSALPARAMETERS	I_1157PROFILEASSETIDX	CLUSTERED INDEX	80	5
ASSETDISPOSALPARAMETERS	I_1157OFFSETLEDGERDIMENSIONIDX	NONCLUSTERED INDEX	80	5
ASSETDISPOSALPARAMETERS	I_1157LEDGERDIMENSIONIDX	NONCLUSTERED INDEX	80	5
HRMAPPLICANTINTERVIEW	I_8002RECID	CLUSTERED INDEX	80	5
USERINFO	I_65531SID	NONCLUSTERED INDEX	80	5
USERINFO	I_65531SIDONLY	NONCLUSTERED INDEX	80	5
AG_SITEISSUESUPPLINK	NULL	HEAP	80	8
WORKCALENDAREMPLOYMENT	I_7295CALENDAR	NONCLUSTERED INDEX	80	5
EPTMPCASHRECEIPT	NULL	HEAP	80	10
HCMPOSITIONWORKERASSIGNMENT	I_6259POSITIONIDX	NONCLUSTERED INDEX	80	5
SALESQUOTATIONHEADERTMP	I_101255RECID	CLUSTERED INDEX	80	5
SQLSYNCINFO	I_65493TABLENAME	CLUSTERED INDEX	80	5
AGREEMENTLINEHISTORY	I_4910RECID	CLUSTERED INDEX	80	5
ASSETLEDGERACCOUNTS	I_1141OFFSETLEDGERDIMENSIONIDX	NONCLUSTERED INDEX	80	5
ASSETLEDGERACCOUNTS	I_1141LEDGERDIMENSIONIDX	NONCLUSTERED INDEX	80	5
ACCOUNTINGEVENT	I_7456IDENTIFICATION	NONCLUSTERED INDEX	79.3103448275862	58
CATEGORYTABLE	I_2611CATEGORYIDX	CLUSTERED INDEX	77.7777777777778	9
INVENTTRANSFERPARMTABLE	I_1707PARMLINEIDX	NONCLUSTERED INDEX	77.7777777777778	9
INVENTTRANSFERPARMTABLE	I_1707RECID	NONCLUSTERED INDEX	77.7777777777778	9
WMSSHIPMENT	I_682RECID	NONCLUSTERED INDEX	77.7777777777778	9
AG_CASHSALESTABLE	I_102311AG_CASHIDX	NONCLUSTERED INDEX	77.7777777777778	9
JMGPROFILEDAY	I_8194PROFILEDAYIDX	CLUSTERED INDEX	77.7777777777778	9
SALESPARMUPDATE	I_1428HCMWORKERIDX	NONCLUSTERED INDEX	77.5401069518717	374
SALESPARMUPDATE	I_1428CUSTOMSSHIPPINGBILLNUMBERTABLE8000	NONCLUSTERED INDEX	77.5401069518717	374
VENDPACKINGSLIPTRANS_INTRASTAT	I_101549RECID	NONCLUSTERED INDEX	77.2727272727273	22
DIMENSIONFOCUSUNPROCESSEDTRANSACTIONS	I_7402RECID	NONCLUSTERED INDEX	77.1428571428572	35
WMSPICKINGROUTE	I_680STATUSIDX	NONCLUSTERED INDEX	76.9230769230769	13
INVENTSUMLOGTTS	I_1267TRANSIDX	NONCLUSTERED INDEX	76.8381083879876	2897
VENDINVOICEINFOLINE_ASSET	I_2627RECID	NONCLUSTERED INDEX	76.4705882352941	17
EPCHEQUE_DETAIL	NULL	HEAP	76.4705882352941	67
SUBLEDGERJOURNALACCOUNTENTRY	I_7459GENERALJOURNALACCOUNTENTRYIDX	NONCLUSTERED INDEX	75.5102040816327	49
TAXUNCOMMITTED	I_2757SOURCEDOCUMENTLINE	NONCLUSTERED INDEX	75.3086419753086	81
CURRENCY	I_047CURRENCYCODEIDX	CLUSTERED INDEX	75	8
SOURCEDOCUMENTLINERELIEVING	I_101278RECID	CLUSTERED INDEX	75	12
NUMBERSEQUENCEDATATYPEPARAMETERTYPE	I_4222RECID	CLUSTERED INDEX	75	4
HRMRECRUITINGTABLE	I_8056RESPIDX	NONCLUSTERED INDEX	75	4
OUTLOOKUSERSETUP	I_7887USERINFOIDX	CLUSTERED INDEX	75	4
DIRNAMESEQUENCETRANSLATION	I_4410RECID	NONCLUSTERED INDEX	75	4
DEL_RELEASEUPDATEDICTIONARIES	I_10026TRANSFORMTABLERECID	NONCLUSTERED INDEX	75	8
TRVADMINCUSTOMFIELDS	I_2069TRVADMINCUSTOMFIELDSIDX	CLUSTERED INDEX	75	4
HCMEMPLOYMENTABSENCESETUP	I_9701HCMEMPLOYMENTABSENCESETUP_AK1	NONCLUSTERED INDEX	75	4
NUMBERSEQUENCEDATATYPE	I_4221RECID	CLUSTERED INDEX	75	8
NUMBERSEQUENCEDATATYPE	I_4221DATATYPEIDX	NONCLUSTERED INDEX	75	4
NUMBERSEQUENCEDATATYPE	I_4221MODULEIDX	NONCLUSTERED INDEX	75	4
AIFACTION	I_580CLASSIDIDX	NONCLUSTERED INDEX	75	8
CUSTACCOUNTSTATEMENTEXTTMP	I_10578RECID	CLUSTERED INDEX	75	8
HCMEMPLOYMENTVACATION	I_9707HCMEMPLOYMENTVACATION_AK1	NONCLUSTERED INDEX	75	4
HCMEMPLOYMENTEMPLOYEE	I_9705HCMEMPLOYMENTEMPLOYEE_AK1	NONCLUSTERED INDEX	75	4
SALESPACKINGSLIPDETAILSTMP	I_101248RECID	CLUSTERED INDEX	75	8
PRINTMGMTREPORTFORMAT	I_10208RECID	CLUSTERED INDEX	75	4
PRINTMGMTREPORTFORMAT	I_10208PRINTFORMATREPORTFORMATTYPE	NONCLUSTERED INDEX	75	4
PSAACTIVITYPROJREQIMPORTANCE	I_100837RECID	CLUSTERED INDEX	75	4
PSAPROJWORKCOMPLETE	I_100882RECID	CLUSTERED INDEX	75	4
PRINTMGMTSETTINGS	I_1618PRINTMGMTSETTINGSIDX	CLUSTERED INDEX	75	4
FISCALCALENDARPERIOD	I_6143CALENDARNAMESTARTDATEIDX	NONCLUSTERED INDEX	75	4
SYSCLIENTSESSIONS	I_65500SERVERID	NONCLUSTERED INDEX	75	4
REQTRANS	I_161REFIDX	NONCLUSTERED INDEX	75	4
INVENTDIMSETUPGRID	I_758DIMFIELDIDX	CLUSTERED INDEX	75	4
NUMBERSEQUENCETABLE_CN	I_100602NUMBERSEQUENCETABLEIDX	NONCLUSTERED INDEX	75	4
AGREEMENTLINERELEASEDLINE	I_5188SALESLINEIDX	NONCLUSTERED INDEX	75	4
HCMJOBDETAIL	I_5167JOBIDX	NONCLUSTERED INDEX	75	4
RETAILCUSTTABLE	I_17269RECID	NONCLUSTERED INDEX	75	4
SRSREPORTPREPROCESSEDDETAILS	I_10396RECID	CLUSTERED INDEX	75	8
VENDINVOICEMATCHINGLINE	I_2231REFIDX	NONCLUSTERED INDEX	75	16
JMGEMPLOYEE	I_8172PROJPERIODTABLEIDX	NONCLUSTERED INDEX	75	4
SUBLEDGERJOURNALACCOUNTENTRYDISTRIBUTION	I_7460ACCOUNTINGDISTRIBUTIONIDX	NONCLUSTERED INDEX	73.4177215189873	79
DIMENSIONFOCUSUNPROCESSEDTRANSACTIONS	I_7402FOCUSDIMENSIONHIERARCHYIDX	CLUSTERED INDEX	73.1707317073171	41
AG_CASHSALESTABLE	I_102311RECID	CLUSTERED INDEX	73.0769230769231	26
TAXUNCOMMITTED	I_2757TAXUNCOMMITTEDBYDOCUMENT	CLUSTERED INDEX	72.9636048526863	1154
VENDINVOICEINFOLINE_ASSET	I_2627VENDINVOICEINFOLINERECIDIDX	CLUSTERED INDEX	72.7272727272727	22
HCMEMPLOYMENT	I_9704HCMEMPLOYMENT_AK1	NONCLUSTERED INDEX	71.4285714285714	7
LEDGERCURRENCYPARAMETERS_RU	I_9586UNREALIZEDPROFITEMPLLEDGERDIM60004	NONCLUSTERED INDEX	71.4285714285714	7
LEDGERCURRENCYPARAMETERS_RU	I_9586UNREALIZEDLOSSEMPLLEDGERDIMEN60005	NONCLUSTERED INDEX	71.4285714285714	7
LEDGERCURRENCYPARAMETERS_RU	I_9586RTAX25PROFITTABLEPROFITCUSTIDX	NONCLUSTERED INDEX	71.4285714285714	7
LEDGERCURRENCYPARAMETERS_RU	I_9586RTAX25PROFITTABLEPROFITVENDIDX	NONCLUSTERED INDEX	71.4285714285714	7
HCMPOSITIONWORKERASSIGNMENT	I_6259RECID	CLUSTERED INDEX	71.4285714285714	7
LEDGERCURRENCYPARAMETERS_RU	I_9586UNREALIZEDLOSSCUSTLEDGERDIMENS8016	NONCLUSTERED INDEX	71.4285714285714	7
LEDGERCURRENCYPARAMETERS_RU	I_9586UNREALIZEDPROFITCUSTLEDGERDIME8017	NONCLUSTERED INDEX	71.4285714285714	7
LEDGERCURRENCYPARAMETERS_RU	I_9586REALIZEDLOSSTAXVENDLEDGERDIMEN8008	NONCLUSTERED INDEX	71.4285714285714	7
LEDGERCURRENCYPARAMETERS_RU	I_9586REALIZEDPROFITTAXVENDLEDGERDIM8009	NONCLUSTERED INDEX	71.4285714285714	7
NUMBERSEQUENCETABLE	I_273RECID	NONCLUSTERED INDEX	70	10
PRODPARMSTATUSDECREASE	I_253RECID	NONCLUSTERED INDEX	70	10
JMGIPCJOURNALTABLE	I_3206IPCJOURNALIDIDX	NONCLUSTERED INDEX	70	30
FORECASTINVENT	I_142ITEMMODELTYPEIDX	CLUSTERED INDEX	68.4931506849315	657
VENDINVOICEINFOSUBLINE	I_1462PARMIDX	NONCLUSTERED INDEX	68	25
EVENTCUD	I_288STATUSIDX	NONCLUSTERED INDEX	68	25
INVENTSUMLOGTTS	I_1267ITEMIDX	NONCLUSTERED INDEX	67.606149341142	2732
RELEASEUPDATEDYNAMICDEPENDENCY	I_100997RECID	CLUSTERED INDEX	66.6666666666667	3
HCMPOSITIONDETAIL	I_6266POSITIONIDX	NONCLUSTERED INDEX	66.6666666666667	3
HCMPOSITIONDETAIL	I_6266DEPARTMENTIDX	NONCLUSTERED INDEX	66.6666666666667	3
HCMPOSITIONDETAIL	I_6266JOBIDX	NONCLUSTERED INDEX	66.6666666666667	3
NUMBERSEQUENCEREFERENCE	I_707NUMBERSEQUENCEDATATYPEIDX	NONCLUSTERED INDEX	66.6666666666667	6
EPTMPPROCESSINFO	I_30030IDX	NONCLUSTERED INDEX	66.6666666666667	3
DEL_NUMBERSEQUENCEREFERENCE	I_4933RECID	NONCLUSTERED INDEX	66.6666666666667	3
SYSCONFIG	I_65514RECID	NONCLUSTERED INDEX	66.6666666666667	3
HRMCOURSEATTENDEE	I_8012RECID	NONCLUSTERED INDEX	66.6666666666667	3
JMGPAYROLLPERIODTRANS	I_8596PAYROLLPERIODIDX	NONCLUSTERED INDEX	66.6666666666667	9
SUBLEDGERJOURNALACCOUNTENTRY	I_7459SUBLEDGERJOURNALENTRYIDX	NONCLUSTERED INDEX	66.6666666666667	42
EVENTRULEDATA	I_293RULEIDX	CLUSTERED INDEX	66.6666666666667	6
PRINTMGMTDOCINSTANCE	I_1600PRINTMGMTDOCINSTANCENAMEIDX	NONCLUSTERED INDEX	66.6666666666667	3
PRINTMGMTDOCINSTANCE	I_1600RECID	NONCLUSTERED INDEX	66.6666666666667	3
PROJSITEISSUESUPPLIERS	NULL	HEAP	66.6666666666667	5
SALESPACKINGSLIPDETAILSTMP	I_101248JOURNALRECID	NONCLUSTERED INDEX	66.6666666666667	3
SMMDELETEDACTIVITIES	I_8158EMPLIDIDX	NONCLUSTERED INDEX	66.6666666666667	3
PRINTMGMTSETTINGS	I_1618RECID	NONCLUSTERED INDEX	66.6666666666667	3
SYSUSERLOG	I_855RECID	NONCLUSTERED INDEX	66.6666666666667	45
HRMABSENCESETUP	I_8349IDIDX	CLUSTERED INDEX	66.6666666666667	3
FISCALCALENDARPERIOD	I_6143FISCALYEARPERIODNAMEIDX	NONCLUSTERED INDEX	66.6666666666667	3
AG_TEMPUSERROLES	I_102310RECID	CLUSTERED INDEX	66.6666666666667	3
AGREEMENTLINEDEFAULT	I_4907RECID	CLUSTERED INDEX	66.6666666666667	3
DEL_SYSUPGRADETIMEZONE	I_2815RECID	NONCLUSTERED INDEX	66.6666666666667	3
DEL_INVENTLOCATIONUPGRADE	I_4679WAREHOUSEIDX	CLUSTERED INDEX	66.6666666666667	3
AG_PSAPROJECTSUPPLIERS	NULL	HEAP	66.6666666666667	3
DIRPERSONUSER	I_4830VALIDFROMIDX	CLUSTERED INDEX	66.6666666666667	6
LOGISTICSADDRESSCOUNTRYREGION	I_2942COUNTRYREGIONIDX	CLUSTERED INDEX	66.6666666666667	3
RELEASEUPDATESPECIALFIELDMAPPING	I_3319NEWMAPPINGIDX	NONCLUSTERED INDEX	66.6666666666667	3
REQTRANS	I_161KEEPIDX	NONCLUSTERED INDEX	66.6666666666667	3
INVENTSUMDELTA	I_2397RECID	NONCLUSTERED INDEX	66.6666666666667	3
SALESQUOTATIONDETAILSTMP	I_101254RECID	CLUSTERED INDEX	66.6666666666667	3
AGREEMENTLINERELEASEDLINE	I_5188CUSTINVOICETRANSIDX	NONCLUSTERED INDEX	66.6666666666667	3
AGREEMENTLINERELEASEDLINE	I_5188PROJINVOICEITEMIDX	NONCLUSTERED INDEX	66.6666666666667	3
AGREEMENTLINERELEASEDLINE	I_5188ALLREFSUNIQUEIDX	NONCLUSTERED INDEX	66.6666666666667	3
SMMAXAPTAOUTLOOKMAPPING	I_1943RECID	NONCLUSTERED INDEX	66.6666666666667	3
VENDRECEIPTSLISTTRANS	I_651RECID	CLUSTERED INDEX	66.6666666666667	3
DEL_SYSRECORDLEVELSECURITY	I_10879RECID	NONCLUSTERED INDEX	66.6666666666667	3
DEL_LEDGERTABLE	I_221DEBCREDBALANCEDEMANDIDX	NONCLUSTERED INDEX	66.6666666666667	3
DEL_LEDGERTABLE	I_221ACCOUNTPLTYPEIDX	NONCLUSTERED INDEX	66.6666666666667	3
DEL_LEDGERTABLE	I_221RECID	NONCLUSTERED INDEX	66.6666666666667	3
HCMPOSITION	I_6202RECID	CLUSTERED INDEX	66.6666666666667	6
AIFPORTACTIONPOLICY	I_7225AIFPORTACTIONPOLICYIDX	CLUSTERED INDEX	66.6666666666667	3
AIFPORTACTIONPOLICY	I_7225RECID	NONCLUSTERED INDEX	66.6666666666667	3
EVENTINBOX	I_289IDX	CLUSTERED INDEX	66.6666666666667	3
SALESPACKINGSLIPHEADERTMP	I_101249JOURNALRECID	NONCLUSTERED INDEX	66.6666666666667	3
USERGROUPINFO	I_10430USERIDX	CLUSTERED INDEX	66.6666666666667	3
DEL_DIRPARTYINTERNALORGANIZATIONTABLE	I_2216ORGFROMTODATESIDX	CLUSTERED INDEX	66.6666666666667	3
AIFSERVICE	I_2222RECID	CLUSTERED INDEX	66.6666666666667	3
PURCHRFQWORKERSETUP	I_5737PURCHRFQWORKERSETUP_AK1	NONCLUSTERED INDEX	66.6666666666667	6
RELEASEUPDATECONFIGKEY	I_6475CONFIGKEYIDX	CLUSTERED INDEX	66.6666666666667	3
DIMENSIONRULE	I_5677NAMEIDX	NONCLUSTERED INDEX	66.6666666666667	3
AG_PRECASTDELEMAIL	I_102316PARMRECIDX	NONCLUSTERED INDEX	66.6666666666667	3
HRMRECRUITINGMEDIA	I_8055RECRUITINGMEDIAIDIDX	CLUSTERED INDEX	66.6666666666667	3
MAINACCOUNT	I_720MAINACCOUNTIDIDX	NONCLUSTERED INDEX	66.6666666666667	3
MAINACCOUNT	I_720MAINACCOUNTANDADJUSTMENTMETHODIDX34	NONCLUSTERED INDEX	66.6666666666667	3
TRVADMINCUSTOMFIELDS	I_2069RECID	NONCLUSTERED INDEX	66.6666666666667	3
LOGISTICSLOCATIONROLETRANSLATION	I_4409RECID	NONCLUSTERED INDEX	66.6666666666667	6
LEDGERFISCALCALENDARPERIOD	I_7080RECID	CLUSTERED INDEX	66.6666666666667	3
WORKCALENDAREMPLOYMENT	I_7295EMPLOYMENT_AK	NONCLUSTERED INDEX	66.6666666666667	3
ASSETCHDRIVERS	NULL	HEAP	66.6666666666667	7
HCMPERSONPRIVATEDETAILS	I_5263HCMPERSONPRIVATEDETAILS_AK1	NONCLUSTERED INDEX	66.6666666666667	9
PURCHPURCHASEORDERTMP	I_5966RECID	CLUSTERED INDEX	66.6666666666667	3
HCMAPPLICANT	I_6912PERSONIDX	NONCLUSTERED INDEX	66.6666666666667	12
BATCH	I_2827SESSIONIDX	NONCLUSTERED INDEX	66.6666666666667	3
HRMVIRTUALNETWORKDEVELOPMENTPLANTABLE	I_102308VIRNETIDIDX	CLUSTERED INDEX	66.6666666666667	6
NUMBERSEQUENCEDATATYPEPARAMETERTYPE	I_4222NUMBERSEQUENCEDATATYPEIDX	NONCLUSTERED INDEX	66.6666666666667	3
SYSUSERLICENSELIST	I_101348RECID	CLUSTERED INDEX	66.6666666666667	3
JMGPAYAGREEMENTLINE	I_8184JMGPROFILETYPETABLEIDX	NONCLUSTERED INDEX	66.6666666666667	3
JMGPAYAGREEMENTLINE	I_8184PAYCOUNTIDX	NONCLUSTERED INDEX	66.6666666666667	3
JMGPAYAGREEMENTLINE	I_8184RECID	NONCLUSTERED INDEX	66.6666666666667	3
USERINFO	I_65531IDONLY	NONCLUSTERED INDEX	66.6666666666667	3
CUSTINVOICEBACKORDERLINE	I_1570INVOICEIDX	NONCLUSTERED INDEX	66.6666666666667	3
HCMPOSITIONDURATION	I_7727RECID	CLUSTERED INDEX	66.6666666666667	6
HCMPOSITIONDURATION	I_7727POSITIONDURATION_AK1	NONCLUSTERED INDEX	66.6666666666667	3
AGDOMESTICFLOORLINES	NULL	HEAP	66.6666666666667	4
DEL_LEDGERPERIOD	I_218ENDIDX	NONCLUSTERED INDEX	66.6666666666667	3
DEL_LEDGERPERIOD	I_218RECID	NONCLUSTERED INDEX	66.6666666666667	3
SYSEXPIMPGROUP	I_422RECID	NONCLUSTERED INDEX	66.6666666666667	3
JMGEMPLOYEE	I_8172PINCODEIDX	NONCLUSTERED INDEX	66.6666666666667	3
AG_SALESINVOICETABLE	I_40085SALESIDX	NONCLUSTERED INDEX	64.5833333333333	96
SRSREPORTQUERY	I_2995USERIDREPORTNAMEPARAMETERNAME	NONCLUSTERED INDEX	64.5161290322581	93
SALESPARMLINE	I_361RECID	NONCLUSTERED INDEX	64.5009416195857	1062
XREFREFERENCES	I_516PATHIDX	NONCLUSTERED INDEX	63.6363636363636	22
CUSTDEFAULTLOCATION	I_4780UNIQUEIDX	CLUSTERED INDEX	63.4146341463415	246
VENDINVOICEMATCHING	I_3034RECID	CLUSTERED INDEX	63.1578947368421	19
AGL_SalesOrders_2014_Errors	NULL	HEAP	63.1578947368421	110
AG_PICKLISTLINES	I_102321RECID	CLUSTERED INDEX	63.0769230769231	65
HCMPERSONCOURSE	I_5152HCMPERSONCOURSE_AK1	NONCLUSTERED INDEX	62.5	8
HRMCOURSEATTENDEE	I_8012PERSONCOURSEIDX	NONCLUSTERED INDEX	62.5	8
SYSCONFIG	I_65514CONFIGTYPE	CLUSTERED INDEX	62.5	8
PROJECTACCOUNTINGDISTRIBUTION	I_7129RECID	CLUSTERED INDEX	62.5	40
VENDINVOICEINFOTABLE	I_1425PURCHIDX	NONCLUSTERED INDEX	61.6822429906542	107
UNITOFMEASURECONVERSIONCACHE	I_4439RECID	CLUSTERED INDEX	61.1111111111111	18
AIFACTION	I_580AIFACTIONIDX	CLUSTERED INDEX	61.1111111111111	18
SUBLEDGERJOURNALENTRY	I_7458RECID	CLUSTERED INDEX	60.9375	64
INVENTITEMLOCATIONCOUNTINGSTATUS	I_11053INVENTDIMIDX	NONCLUSTERED INDEX	60.634328358209	536
ACCOUNTINGDISTRIBUTION	I_7452ACCOUNTINGEVENTIDX	NONCLUSTERED INDEX	60.2409638554217	83
HCMEMPLOYMENTDETAIL	I_9706RECID	CLUSTERED INDEX	60	10
INVENTLOCATION	I_158INVENTLOCATIONIDX	CLUSTERED INDEX	60	5
SMMCONTACTPERSONSYNCHRONIZE	I_8412ENTRYIDIDX	NONCLUSTERED INDEX	60	5
AG_EST_ULTVISITS	I_40026RECID	NONCLUSTERED INDEX	60	10
NUMBERSEQUENCESCOPE	I_4224RECID	CLUSTERED INDEX	60	5
SALESPARMUPDATE	I_1428PARMIDIDX	CLUSTERED INDEX	59.3707250341997	731
FORECASTINVENT	I_142ITEMMODELIDX	NONCLUSTERED INDEX	59.2920353982301	339
PROJTRANSBUDGET	I_1929CATEGORYIDX	NONCLUSTERED INDEX	59.1093117408907	247
SUBLEDGERJOURNALACCOUNTENTRYDISTRIBUTION	I_7460RECID	NONCLUSTERED INDEX	58.974358974359	78
PROJFUNDINGSOURCE	I_2424PSACUSTOMERRETENTIONTERMTABLEIDX	NONCLUSTERED INDEX	58.3333333333333	24
ACCOUNTINGDISTRIBUTION	I_7452RECID	NONCLUSTERED INDEX	57.7777777777778	90
PROJTRANSBUDGET	I_1929TRANSIDX	CLUSTERED INDEX	57.2573463935886	1123
VENDINVOICEINFOLINE	I_1430ORIGPURCHIDIDX	NONCLUSTERED INDEX	57.2192513368984	187
HCMJOB	I_4497RECID	CLUSTERED INDEX	57.1428571428571	7
SYSSETUPLOG	I_1518KEYIDX	CLUSTERED INDEX	57.1428571428571	7
VENDINVOICEPACKINGSLIPQUANTITYMATCH	I_7311REFIDX	NONCLUSTERED INDEX	57.1428571428571	14
HCMWORKER	I_5116HCMWORKER_AK1	NONCLUSTERED INDEX	57.1428571428571	7
NUMBERSEQUENCEREFERENCE	I_707NATURALKEY	NONCLUSTERED INDEX	57.1428571428571	7
SECURITYUSERROLE	I_65492RECIDIDX	NONCLUSTERED INDEX	57.1428571428571	7
JMGCHANGELOG	I_3350WORKERPROFILEDATEIDX	CLUSTERED INDEX	56.9031498380924	3397
ACCOUNTINGEVENT	I_7456RECID	CLUSTERED INDEX	56.5217391304348	69
SALESPARMLINE	I_361PARMIDORIGSALESIDX	NONCLUSTERED INDEX	55.9028932490855	3007
JMGIPCJOURNALTABLE	I_3206RECID	CLUSTERED INDEX	55.7377049180328	61
DEL_SYSCOMPANYUSERINFO	I_1124USERIDX	CLUSTERED INDEX	55.5555555555556	9
SMMTMCALLLISTTABLE	I_8317CONTACTIDX	NONCLUSTERED INDEX	55.5555555555556	9
HRMRECRUITINGTABLE	I_8056IDIDX	CLUSTERED INDEX	55.5555555555556	9
SUBLEDGERJOURNALACCOUNTENTRYDISTRIBUTION	I_7460SUBLEDGERJOURNALACCOUNTENTRYDISTR3	NONCLUSTERED INDEX	55.1282051282051	78
CUSTINVOICEPACKINGSLIPQUANTITYMATCH	I_7229INVOICESOURCEDOCUMENTLINEIDX	NONCLUSTERED INDEX	55.0724637681159	69
AG_PROSPECTIVESPEC	NULL	HEAP	54.5454545454545	39
SYSLASTVALUE	I_65528USERID	CLUSTERED INDEX	54.3793911007026	4270
PROJTRANSBUDGET	I_1929LEDGERDIMENSIONIDX	NONCLUSTERED INDEX	54.337899543379	219
JMGJOBDOCUREF	I_5342DOCREFINDEX	CLUSTERED INDEX	53.8461538461538	130
INVENTSUMDELTA	I_2397TTSITEMDIMIDX	CLUSTERED INDEX	53.8461538461538	13
INVENTSUMLOGTTS	I_1267TTSIDIDX	CLUSTERED INDEX	53.6106296938186	10386
XREFREFERENCES	I_516REFERENCEPATHRECID	NONCLUSTERED INDEX	53.5714285714286	28
INVENTMODELGROUPITEM	I_7053ITEMMODELGROUPIDX	NONCLUSTERED INDEX	52.7472527472528	91
VENDINVOICEINFOSUBLINE	I_1462REFIDX	CLUSTERED INDEX	52.5423728813559	59
AG_CASHSALESLINE	I_102312RECID	CLUSTERED INDEX	51.5625	64
PROJTRANSBUDGET	I_1929EMPLITEMIDX	NONCLUSTERED INDEX	51.5555555555556	225
WMSORDER	I_666STATUSIDX	NONCLUSTERED INDEX	50.9433962264151	53
TAXUNCOMMITTED	I_2757RECID	NONCLUSTERED INDEX	50.5882352941176	85
FORECASTINVENT	I_142REFIDX	NONCLUSTERED INDEX	50.3579952267303	419
JMGTIMECALCPARMETERS	I_8491PROFILESTAMPSPEC	CLUSTERED INDEX	50	2
AIFCHANNEL	I_1111AIFCHANNELIDX	CLUSTERED INDEX	50	2
BATCH	I_2827BATCHIDX	NONCLUSTERED INDEX	50	2
HRMVIRTUALNETWORKDEVELOPMENTPLANTABLE	I_102308RECID	NONCLUSTERED INDEX	50	2
BATCH	I_2827BATCHJOBID	NONCLUSTERED INDEX	50	2
BATCH	I_2827STATUSUSER	NONCLUSTERED INDEX	50	2
PAYROLLPAYPERIOD	I_100651PAYPERIOD_AK1	CLUSTERED INDEX	50	2
AG_CAPACITYBREAKDOWN	I_40057RECID	NONCLUSTERED INDEX	50	2
TIMEZONESLIST	I_65496TZENUM	CLUSTERED INDEX	50	2
AG_TOP10ITEMS	I_40081ORDERVALUE	NONCLUSTERED INDEX	50	2
AG_SITEISSUESUPPLINK	I_40074RECID	NONCLUSTERED INDEX	50	2
RELEASEUPDATEPRIORITIZEDJOBS	I_4877RECID	CLUSTERED INDEX	50	2
HRMAPPLICANTINTERVIEW	I_8002APPLICATIONIDX	NONCLUSTERED INDEX	50	2
DEL_NUMBERSEQUENCETABLE	I_4934RECID	NONCLUSTERED INDEX	50	2
CUSTGROUP	I_057BANKCUSTPAYMIDTABLEIDX	NONCLUSTERED INDEX	50	6
AG_BULKJNLTRANSFER	I_102319RECID	CLUSTERED INDEX	50	6
DEL_DIRORGANIZATIONDETAIL	I_2360PARTYIDIDX	CLUSTERED INDEX	50	2
DEL_ADDRESSCOUNTY	I_046COUNTYIDX	NONCLUSTERED INDEX	50	4
JMGPROFILETABLE	I_8200PROFILEIDX	CLUSTERED INDEX	50	2
SYSEXPIMPGROUP	I_422GROUPIDX	CLUSTERED INDEX	50	4
SMMPHONEPARAMETERS	I_8313NAMEIDX	NONCLUSTERED INDEX	50	10
ISOCURRENCYCODE	I_2469ISOCURRENCYCODEIDX	CLUSTERED INDEX	50	2
DEL_HRMSKILL	I_8059IDIDX	CLUSTERED INDEX	50	2
DEL_DIRPARTYINTERNALORGANIZATIONTABLE	I_2216HCMWORKERIDX	NONCLUSTERED INDEX	50	2
DOCUTABLE	I_098TYPEIDX	CLUSTERED INDEX	50	2
TAXDATA	I_429FORMSORTIDX	CLUSTERED INDEX	50	2
AIFSERVICE	I_2222AIFEXTERNALNAMEIDX	NONCLUSTERED INDEX	50	2
DEL_NUMBERSEQUENCEHISTORY	I_4931RECID	NONCLUSTERED INDEX	50	2
AG_LATEPROJTABLE	NULL	HEAP	50	4
COMPANYIMAGE	I_1394REFIDX	CLUSTERED INDEX	50	2
DEL_INVENTDIMSETUP	I_700DIMGROUPIDX	CLUSTERED INDEX	50	4
DEL_HRPPARTYJOBTABLE	I_2215JOBIDX	CLUSTERED INDEX	50	6
LOGISTICSADDRESSFORMATLINES	I_2945ADDRFORMATLINEIDX	CLUSTERED INDEX	50	2
DIMENSIONRULE	I_5677RECID	CLUSTERED INDEX	50	4
INTERCOMPANYENDPOINTACTIONPOLICYTRANSFER	I_399INTERCOMPANYENDPOINTACTIONPOLICYIDX	CLUSTERED INDEX	50	4
INTERCOMPANYENDPOINTACTIONPOLICYTRANSFER	I_399RECID	NONCLUSTERED INDEX	50	2
VENDEXCHRATEADJUSTMENT	I_1127RECID	CLUSTERED INDEX	50	2
PRICEDISCGROUP	I_312PRICEDISCGROUP	CLUSTERED INDEX	50	2
DOCUFIELD	I_094TYPEIDLINIDX	NONCLUSTERED INDEX	50	2
BATCHJOB	I_2096STATUSRECID	NONCLUSTERED INDEX	50	2
JMGCLIENTFIELDTABLE	I_4893RECID	CLUSTERED INDEX	50	2
JMGCLIENTFIELDTABLE	I_4893GRIDSETUPLIMIT	NONCLUSTERED INDEX	50	2
LEDGERFISCALCALENDARPERIOD	I_7080LEDGERFISCALCALENDARPERIODIDX	NONCLUSTERED INDEX	50	2
CATEGORYTABLE	I_2611SHAREDCATEGORYIDX	NONCLUSTERED INDEX	50	4
SALESCONFIRMHEADERTMP	I_101239RECID	CLUSTERED INDEX	50	2
DEL_PSAPROJQUOTETRANS	I_102134RECTABLEIDX	CLUSTERED INDEX	50	2
DEL_PSAPROJQUOTETRANS	I_102134RECID	NONCLUSTERED INDEX	50	2
HCMEMPLOYMENTABSENCESETUP	I_9701RECID	CLUSTERED INDEX	50	14
DEL_AIFUPGRADESERIALIZABLECLASSIDMAP	NULL	HEAP	50	5
DIMENSIONRULECRITERIA	I_5679DIMENSIONATTRIBUTELDX	NONCLUSTERED INDEX	50	2
DIMENSIONRULECRITERIA	I_5679DIMENSIONRULEATTRIBUTEIDX	NONCLUSTERED INDEX	50	2
AGREEMENTHEADER	I_4895RECID	CLUSTERED INDEX	50	2
MDLPAYPREVIOUSEMPLOYMENT	I_30091PRIMARYIDX	CLUSTERED INDEX	50	4
DOCUFILETYPES	I_1133FILETYPEIDX	CLUSTERED INDEX	50	2
MAINACCOUNT	I_720DEL_LEDGERACCOUNTNUMFORMAT_CNIDX	NONCLUSTERED INDEX	50	2
SMADISPATCHWORKERSETUP	I_5745SMADISPATCHWORKERSETUP_AK1	NONCLUSTERED INDEX	50	6
HRMRECRUITINGMEDIA	I_8055RECID	NONCLUSTERED INDEX	50	2
AGREEMENTHEADERHISTORY	I_4633RECID	CLUSTERED INDEX	50	2
DEL_SYSCOMPANYUSERINFO	I_1124PARTYIDX	NONCLUSTERED INDEX	50	2
DEL_SYSCOMPANYUSERINFO	I_1124RECID	NONCLUSTERED INDEX	50	2
DIRPERSONUSER	I_4830DIRPERSONIDX	NONCLUSTERED INDEX	50	2
DIRPERSONUSER	I_4830RECID	NONCLUSTERED INDEX	50	2
TAXREPORTPERIOD	I_437TAXPERIODIDX	CLUSTERED INDEX	50	2
LOGISTICSADDRESSCOUNTRYREGION	I_2942LOGISTICSADDRESSFORMATHEADINGIDX	NONCLUSTERED INDEX	50	2
AIFPORT	I_7174NAMEIDX	CLUSTERED INDEX	50	2
ASSETGROUP	I_1139GROUPIDX	CLUSTERED INDEX	50	2
NUMBERSEQUENCEHISTORY	I_521NUMBERSEQIDX	NONCLUSTERED INDEX	50	6
EPCHEQUE_DETAIL	I_30058IDX	NONCLUSTERED INDEX	50	2
EPCHEQUE_DETAIL	I_30058CHEQUENUMIDX	NONCLUSTERED INDEX	50	2
PROJCATEGORY	I_582TYPEIDX	NONCLUSTERED INDEX	50	2
PROJCATEGORY	I_582RECID	NONCLUSTERED INDEX	50	2
REQTRANS	I_161REQUISITIONLINEIDX	NONCLUSTERED INDEX	50	2
REQTRANS	I_161REQPROCESSIDX	NONCLUSTERED INDEX	50	2
REQTRANS	I_161FUTURESIDX	NONCLUSTERED INDEX	50	2
REQTRANS	I_161ACTIONIDX	NONCLUSTERED INDEX	50	2
INVENTSUMDELTA	I_2397TTSDIMIDX	NONCLUSTERED INDEX	50	2
INVENTLOCATION	I_158SITEIDX	NONCLUSTERED INDEX	50	2
LEDGERJOURNALNAME	I_210JOURNALNAMEIDX	CLUSTERED INDEX	50	4
DEL_USERINFO	I_6440PRIMARYKEY	NONCLUSTERED INDEX	50	2
DEL_USERINFO	I_6440SIDKEY	NONCLUSTERED INDEX	50	4
PRODSTATUSPARAMETERS	I_310FROMTOSTATUSIDX	CLUSTERED INDEX	50	4
DEL_RELEASEUPDATETRANSFORMTABLE	I_3311RECID	NONCLUSTERED INDEX	50	2
AG_PRECASTWEEKS	I_40059WEEKNUM	NONCLUSTERED INDEX	50	2
SHAREDCATEGORYROLES	I_4259RECID	CLUSTERED INDEX	50	2
WMSSHIPMENT	I_682SHIPMENTIDIDX	CLUSTERED INDEX	50	24
AGREEMENTLINERELEASEDLINE	I_5188AGREEMENTLINEIDX	NONCLUSTERED INDEX	50	2
SHAREDCATEGORY	I_101268RECID	CLUSTERED INDEX	50	2
CUSTEXCHRATEADJUSTMENT	I_1126RECID	CLUSTERED INDEX	50	2
DEL_LEDGERTABLE	I_221PARENTIDX	NONCLUSTERED INDEX	50	2
TAXREPORTVOUCHER	I_438DATEPERIODIDX	CLUSTERED INDEX	50	2
INVENTITEMGROUP	I_152ITEMGROUPIDX	CLUSTERED INDEX	50	4
LOGISTICSADDRESSCOUNTY	I_2943COUNTRYREGIONSTATECOUNTYIDX	CLUSTERED INDEX	50	4
LOGISTICSADDRESSCOUNTY	I_2943COUNTYIDX	NONCLUSTERED INDEX	50	2
LOGISTICSADDRESSCOUNTY	I_2943RECID	NONCLUSTERED INDEX	50	2
USERGROUPINFO	I_10430RECID	NONCLUSTERED INDEX	50	2
SYSDATAIMPLOGREF	I_1821RECID	CLUSTERED INDEX	50	2
DEL_HRMPOSITION	I_8042IDIDX	NONCLUSTERED INDEX	50	4
DEL_HRMPOSITION	I_8042ORGANIZATIONIDX	NONCLUSTERED INDEX	50	4
TAXTABLE	I_439TAXIDX	CLUSTERED INDEX	50	2
INVENTITEMGROUPFORM	I_10135RECID	NONCLUSTERED INDEX	50	16
EVENTINBOX	I_289USRIDX	NONCLUSTERED INDEX	50	2
PURCHPURCHASEORDERHEADER	I_100966RECID	CLUSTERED INDEX	50	2
PRODPARMSTATUSDECREASE	I_253NUMPRODNUMIDX	NONCLUSTERED INDEX	50	14
MAINACCOUNTLEGALENTITY	I_6902RECID	CLUSTERED INDEX	50	4
MAINACCOUNTLEGALENTITY	I_6902MAINACCOUNTLEGALENTITY	NONCLUSTERED INDEX	50	2
CURRENCYGENDER	I_7888RECID	CLUSTERED INDEX	50	2
SMMCONTACTPERSONSYNCHRONIZE	I_8412USERIDCONTACTPERSONIDIDX	CLUSTERED INDEX	50	6
FISCALCALENDARPERIOD	I_6143TYPE	NONCLUSTERED INDEX	50	2
DEL_SYSSETUPLOG	I_3313TIMEIDX	NONCLUSTERED INDEX	50	4
AG_PSAPROJECTEMPLOYEES	NULL	HEAP	50	3
DEL_AIFUPGRADESERVICENODEMAP	NULL	HEAP	50	5
HCMPOSITIONDETAIL	I_6266HCMPOSITIONTYPEIDX	NONCLUSTERED INDEX	50	2
RELEASEUPDATEDYNAMICDEPENDENCY	I_100997DEPENDENCY	NONCLUSTERED INDEX	50	2
BANKRECONCILIATIONSUMMARYTMP	I_5938RECID	CLUSTERED INDEX	50	2
PROJSTATUSTYPERULE	I_307PROJSTATUSTYPERULEIDX	CLUSTERED INDEX	50	2
PROJSTATUSTYPERULE	I_307RECID	NONCLUSTERED INDEX	50	2
FORECASTMODEL	I_135MODELIDX	CLUSTERED INDEX	50	2
HRMABSENCECODE	I_8347IDIDX	CLUSTERED INDEX	50	2
JOURNALERROR	I_1218REFVOUCHERIDX	NONCLUSTERED INDEX	50	8
FISCALCALENDARPERIOD	I_6143STARTDATEPERIODNAMEFISCALCALENDAR2	NONCLUSTERED INDEX	50	4
HRMABSENCESETUP	I_8349RESPONSIBLEIDX	NONCLUSTERED INDEX	50	2
VENDRECEIPTSLISTJOUR	I_650RECID	CLUSTERED INDEX	50	2
XREFREFERENCES	I_516NAMEPATHIDS	NONCLUSTERED INDEX	50	22
JMGEMPLOYEE	I_8172RECID	NONCLUSTERED INDEX	50	2
CUSTVENDPAYMPROPOSALTMP	I_10600RECID	CLUSTERED INDEX	50	2
HRMABSENCEREQUEST	I_8600RECID	CLUSTERED INDEX	50	2
HRMABSENCEREQUEST	I_8600EMPLIDREQUESTDATEIDX	NONCLUSTERED INDEX	50	2
AG_PREJOBCOSTING	I_40065RECID	NONCLUSTERED INDEX	50	2
ASSETLEDGERACCOUNTS	I_1141RECID	NONCLUSTERED INDEX	50	2
PROJVISITSITEISSUESEMAILLOG	I_40036RECID	NONCLUSTERED INDEX	50	4
PROJTRANSBUDGET	I_1929SUBSCRIPTIONIDIDX	NONCLUSTERED INDEX	49.2890995260664	211
PROJTRANSBUDGET	I_1929HCMWORKERIDX	NONCLUSTERED INDEX	48.9626556016597	241
JMGCHANGELOG	I_3350RECID	NONCLUSTERED INDEX	48.6725663716814	113
DIMENSIONATTRIBUTEVALUECOMBINATIONSTATUS	I_388RECID	NONCLUSTERED INDEX	48.5714285714286	35
VENDINVOICEPACKINGSLIPQUANTITYMATCH	I_7311RECID	CLUSTERED INDEX	48	25
VENDINVOICEINFOLINE	I_1430INVENTTRANSIDX	NONCLUSTERED INDEX	47.8609625668449	374
JMGIPCTRANS	I_3208RECID	CLUSTERED INDEX	47.1153846153846	104
AIFWCFCONFIGURATION	I_7556RECID	CLUSTERED INDEX	46.6666666666667	15
AG_CASHSALESLINE	I_102312AG_CASHIDX	NONCLUSTERED INDEX	46.6666666666667	15
HCMEMPLOYMENTVACATION	I_9707RECID	CLUSTERED INDEX	46.1538461538462	13
VENDTABLE	I_505PARTY	NONCLUSTERED INDEX	46.1538461538462	13
SALESPARMTABLE	I_360SALESIDIDX	NONCLUSTERED INDEX	45.3300124533001	8030
WMSPICKINGROUTELINK	I_2747RECID	CLUSTERED INDEX	43.75	16
DEL_HRPPARTYJOBTABLERELATIONSHIP	I_2225JOBFROMTODATESIDX	CLUSTERED INDEX	43.75	16
PROJVISITITEMS	NULL	HEAP	43.75	75
PROJTRANSBUDGET	I_1929PROJIDX	NONCLUSTERED INDEX	43.2900432900433	231
HCMPERSONALCONTACTRELATIONSHIP	I_10664PERSONALCONTACTRELATIONSHIP_AK1	CLUSTERED INDEX	42.8571428571429	7
SMMTMCALLLISTTABLE	I_8317CALLLISTRESPONSIBLEEMPLIDIDX	NONCLUSTERED INDEX	42.8571428571429	7
SALESPACKINGSLIPHEADERTMP	I_101249RECID	CLUSTERED INDEX	42.8571428571429	7
SYSDATABASELOG	I_943TABLERECIDIDX	CLUSTERED INDEX	42.8571428571429	7
COMPANYCURRENCYCONVERSION	I_1364EXTENDEDTYPEIDX	NONCLUSTERED INDEX	42.8571428571429	7
PROJTRANSBUDGET	I_1929PROJFUNDINGSOURCEIDX	NONCLUSTERED INDEX	42.5837320574163	209
PROJTRANSBUDGET	I_1929DEFAULTDIMENSIONIDX	NONCLUSTERED INDEX	42.5742574257426	202
VENDINVOICEINFOLINE_PROJECT	I_2730RECID	CLUSTERED INDEX	42.1052631578947	19
VENDINVOICEMATCHINGLINE	I_2231RECID	CLUSTERED INDEX	41.0526315789474	95
JMGEMPLOYEE	NULL	HEAP	40	25
JMGPROFILEDAY	I_8194RECID	NONCLUSTERED INDEX	40	5
RELEASEUPDATETRANSFORMTARGETFIELD	I_3323RECID	CLUSTERED INDEX	40	5
HRMCOURSEATTENDEE	I_8012DEFAULTDIMENSIONIDX	NONCLUSTERED INDEX	40	5
AG_EST_ULTVISITS	NULL	HEAP	40	50
HRMCOURSETABLE	I_8017IDIDX	CLUSTERED INDEX	40	5
SYSSETUPLOG	I_1518NAMEDESCIDX	NONCLUSTERED INDEX	40	5
DEL_HRMPOSITION	I_8042RECID	NONCLUSTERED INDEX	40	5
DEL_LEDGERTABLE	I_221ACCOUNTALIASIDX	NONCLUSTERED INDEX	40	5
VENDTRANSOPEN	I_866REFRECIDX	NONCLUSTERED INDEX	40	45
DEL_ADDRESSCOUNTY	I_046RECID	NONCLUSTERED INDEX	40	5
INVENTPICKINGLISTTOPACKINGSLIPTOP	I_30054SESSIONPICKIDX	NONCLUSTERED INDEX	40	5
INVENTPICKINGLISTTOPACKINGSLIPTOP	I_30054SESSIONORDERPICKIDX	NONCLUSTERED INDEX	40	5
SMMQUOTATIONDOCUCONCLUSIONGROUP	I_8282NAMEIDX	CLUSTERED INDEX	40	5
DEL_NUMBERSEQUENCEHISTORY	I_4931NUMBERSEQIDX	NONCLUSTERED INDEX	40	5
DEL_EMPLTABLE	I_103PARTYIDX	NONCLUSTERED INDEX	40	10
DIMENSIONRULECRITERIA	I_5679RECID	CLUSTERED INDEX	40	5
CUSTCOLLECTIONLETTERJOUR	I_051CUSTBILLINGCLASSIFICATIONIDX	NONCLUSTERED INDEX	40	10
SUBLEDGERJOURNALACCOUNTENTRYDISTRIBUTION	I_7460DISTRIBUTIONSUBLEDGERJOURNALLINE	CLUSTERED INDEX	38.8888888888889	162
JMGIPCJOURNALTRANS	I_3207RECID	CLUSTERED INDEX	38.7931034482759	116
HCMEMPLOYMENTEMPLOYEE	I_9705RECID	CLUSTERED INDEX	38.4615384615385	13
ASSETTRANS	I_1169TRANSTYPEIDX	CLUSTERED INDEX	37.9556500607533	6584
DEL_SYSSETUPLOG	I_3313KEYIDX	CLUSTERED INDEX	37.5	8
HCMWORKER	I_5116HCMWORKER_AK2	NONCLUSTERED INDEX	37.5	8
VENDBANKACCOUNT	I_489RECIDIDX	NONCLUSTERED INDEX	37.5	8
VENDBANKACCOUNT	I_489DIRDUNSNUMBERIDX	NONCLUSTERED INDEX	37.5	8
VENDBANKACCOUNT	I_489BANKCONSTANTSYMBOLIDX	NONCLUSTERED INDEX	37.5	8
DEL_EMPLTABLE	I_103ALTNUMIDX	NONCLUSTERED INDEX	37.5	8
INVENTTRANSORIGINTRANSFER	I_2643ISSUEINVENTTRANSORIGINIDX	CLUSTERED INDEX	37.037037037037	27
XREFREFERENCES	I_516RECID	NONCLUSTERED INDEX	37.037037037037	27
WMSORDER	I_666RECID	NONCLUSTERED INDEX	36.3636363636364	55
PROJTRANSBUDGET	I_1929VOUCHERDATEIDX	NONCLUSTERED INDEX	35.3982300884956	226
INVENTTRANSORIGINTRANSFER	I_2643RECID	NONCLUSTERED INDEX	35.2941176470588	17
SALESINVOICEHEADERFOOTERTMP	I_101240RECID	CLUSTERED INDEX	35	20
VENDTRANSOPEN	I_866RECID	NONCLUSTERED INDEX	34.0425531914894	47
VENDPURCHORDERJOUR	I_502VENDIDX	NONCLUSTERED INDEX	34.006734006734	297
WMSORDERTRANS	I_716RECID	NONCLUSTERED INDEX	33.9285714285714	56
JOURNALERROR	I_1218RECID	NONCLUSTERED INDEX	33.3333333333333	9
CUSTINVOICETABLE	I_1209WORKERSALESTAKERIDX	NONCLUSTERED INDEX	33.3333333333333	18
DEL_ADDRESSCOUNTYUPGRADE	I_3608RECID	CLUSTERED INDEX	33.3333333333333	9
AG_PROSPECTIVETABLE	I_40078SALESREPIDX	NONCLUSTERED INDEX	33.3333333333333	12
INVENTTRANSORIGINTRANSFER	I_2643RECEIPTINVENTTRANSORIGINIDX	NONCLUSTERED INDEX	33.3333333333333	18
DEL_SYSSETUPLOG	I_3313NAMEDESCIDX	NONCLUSTERED INDEX	33.3333333333333	6
PROSPECTIVEBACK	I_40079RECID	NONCLUSTERED INDEX	33.3333333333333	6
WORKCALENDARDATELINE	I_508RECID	NONCLUSTERED INDEX	33.3333333333333	15
RELEASEUPDATETRANSFORMTABLE	I_3322RECID	NONCLUSTERED INDEX	33.3333333333333	6
PROJCATEGORY	I_582CATEGORYIDX	CLUSTERED INDEX	33.3333333333333	6
SMMTMCALLLISTTABLE	I_8317ACTIVITY	NONCLUSTERED INDEX	33.3333333333333	6
TAXWITHHOLDTRANS	I_1816FK_DIMENSIONATTRIBUTEVALUECOMBINA8	NONCLUSTERED INDEX	33.3333333333333	15
RELEASEUPDATEBULKCOPYTABLE	I_3318RECID	NONCLUSTERED INDEX	33.3333333333333	9
BATCH	I_2827RECID	CLUSTERED INDEX	33.3333333333333	3
DEL_AIFUPGRADESERVICECLASSIDMAP	NULL	HEAP	33.3333333333333	5
TRVADMINCUSTOMFIELDS	I_2069REFTABLEIDIDX	NONCLUSTERED INDEX	33.3333333333333	3
HCMPOSITIONWORKERASSIGNMENT	I_6259WORKERIDX	NONCLUSTERED INDEX	33.3333333333333	3
EUSALESLIST	I_543DISPATCHIDX	CLUSTERED INDEX	33.3333333333333	6
SUBLEDGERJOURNALACCOUNTENTRY	I_7459RECID	CLUSTERED INDEX	32.4675324675325	231
AG_PROSPECTIVETABLE	NULL	HEAP	31.8181818181818	125
PRODPARMSTATUSDECREASE	I_253NUMLINENUMIDX	CLUSTERED INDEX	31.8181818181818	22
SPECTRANS	I_417RECID	CLUSTERED INDEX	31.6916488222698	467
SRSTMPDATASTORE	I_4886RECID	CLUSTERED INDEX	31.6176470588235	136
AG_PROSPECTIVESPEC	I_40077PROSPECTIVEIDX	NONCLUSTERED INDEX	31.25	16
HRMVIRTUALNETWORKDEVELOPMENTPLANLINE	I_102307NETPLANIDX	CLUSTERED INDEX	31.25	16
SALESPARMLINE	I_361PARMTABLEREFIDX	NONCLUSTERED INDEX	30.2550855666774	3097

Cheers

Paul

Well formatting was not good but I can confirm that almost all indexes has page_count< 1000 and there is NO NEED to rebuild index which has page count <1000. Even if you rebuild such indexes fragmentation remains due to virtue of fact that pages to such indexes are allocated from mixed extent and they are Scattered and hence creating logical fragmentation. This is not going to affect database performance in any way and Microsoft says the same SO NEED TO WORRY.

As to why fragmentation remain please read below article it would help you in understanding

http://social.technet.microsoft.com/wiki/contents/articles/28182.sql-server-in-depth-what-can-cause-index-to-be-still-fragmented-after-rebuild.aspx

You can use Ola hallengren Script for index rebuild which is smart one

Cheers MVP. Thanks for the help.

Hello ,

Please read the article :

Dynamics AX, Index Fragmentation, and You

http://blogs.msdn.com/b/axinthefield/archive/2013/10/03/dynamics-ax-index-fragmentation-and-you.aspx?wa=wsignin1.0

Hi,

In my mind, this is a composite issue - the other responding to this thread, have given good input on the general level. I work at a Partner and we always implement Index Maintenance routines that runs every night including updating statistics (IndexOptimize from Ola Hallengren). AX 2012 can be said to be les prone to Logical Fragmentation due to reliying more on RecId References which will lead to Index Lookup Operations which is never prone to Logical Fragmentation. But it still exists indexes used for Range Scans that are prone to Logical Fragmentation.

The reson for me to describe this as an composite issue is the fact that several of the standard indexes in AX 2012, consists columns that are frequently updated. This hits especially hard for Clustered Indexes and leads to what I Call hidden performance impacts because SQL Server must spend time re-allocating pages. A good Clustered Index should never consist of a column that is frequently updated and the key is that this leads to Page Splits "in the middle" of the index structure (B+ Tree).

Without looking at the possibility of altering the worst indexes, one possible countermeasure is to define a better value for Fillfactor for affected indexes. This will reduce the number of Page Splits and it will also increase the time Windows for when Logical Fragmentation becomes a possible issue. Do not set Fillfactor at the Instance Level (would lead to wasting Storage), but implement a New Fillfactor (70-80-90 range) for the indexes having Heavy Page Splitting and indexes quickly getting fragmented.

Hope this helps to improve the situation.

Br

Hans-Petter Lund, Norway