Epicor 10 Table Indexes - Erp.GLJrnDtl & Erp.TranGLC

Epicor ERP 10
1

I’m new to Epicor but I have past experience with SQL Server. Doing a little poking around I found that two tables in our Epicor database equates to over half of our entire database size, these tables are Erp.GLJrnDtl and Erp.TranGLC.

The table Erp.GLJrnDtl and Erp.TranGLC themselves aren’t very large being 10 GB and 8.5 GB respectively. The indexes on the other hand are 33 GB and 31 GB respectively.

Looking at the indexes themselves we have 31 non clustered indexes on Erp.GLJrnDtl and another 16 non clustered indexes on Erp.TranGLC. Are all of these stock Epicor indexes or were these added by us?

Thanks for your help.

image
image.png786×584 12.3 KB

2

The Data Dictionary viewer shows:
32 indexes for GLJrnDtl

PK_GLJrnDtl
IX_GLJrnDtl_SysIndex
IX_GLJrnDtl_AllocationBatch
IX_GLJrnDtl_AllocationStamp
IX_GLJrnDtl_BookAPInvIdx
IX_GLJrnDtl_BookARInvIdx
IX_GLJrnDtl_BookBalanceAcct
IX_GLJrnDtl_BookBankCheckIdx
IX_GLJrnDtl_BookBankSlipIndex
IX_GLJrnDtl_BookCheckNumIndex
IX_GLJrnDtl_BookCOAAccount
IX_GLJrnDtl_BookDailyBal
IX_GLJrnDtl_BookFiscalGLAccount
IX_GLJrnDtl_BookFisYearCodeNum
IX_GLJrnDtl_BookJEDate
IX_GLJrnDtl_BookJournalSeq
IX_GLJrnDtl_BookPerBal
IX_GLJrnDtl_BookPeriodDateIdx
IX_GLJrnDtl_BookReconciled
IX_GLJrnDtl_BookRefCode
IX_GLJrnDtl_BookTBFlag
IX_GLJrnDtl_BookTrialAcct
IX_GLJrnDtl_COACode
IX_GLJrnDtl_CorrIDX
IX_GLJrnDtl_FiscalCalYrSufPeriod
IX_GLJrnDtl_MatchCode
IX_GLJrnDtl_SegVal1SegVal2SegVal3
IX_GLJrnDtl_StatUOM
IX_GlJrnDtl_ParentIdx
IX_GlJrnDtl_ParentIdx2
IX_GLJrnDtl_ABTUID
IX_GLJrnDtl_Srch_Rpt

17 indexes for TranGLC

PK_TranGLC
IX_TranGLC_SysIndex
IX_TranGLC_abtuid
IX_TranGLC_BookInvoiceCr
IX_TranGLC_BookInvoiceDb
IX_TranGLC_BookJrnlRef
IX_TranGLC_BookLaborDtl
IX_TranGLC_BookTranNum
IX_TranGLC_COACodeGLAcct
IX_TranGLC_CorrIDx
IX_TranGLC_GLAcctContext
IX_TranGLC_SysGLControlType
IX_TranGLC_TypeCode
IX_TranGLC_UserCanModify
IX_TranGLC_GLControlSearch
IX_TranGLC_MovementNum
IX_TranGLC_FiscalCalendar
3

Thank you Calvin.