E10 Database Schema Question

#ygrps-yiv-208063586 {font-family:'Times New Roman';font-size:13px;}
I did a quick query and it appears all the tables you normally use in E10 (Erp and Ice schemas) contain clustered indexes.  We have tables in the dbo schema are not indexed but I assume this data is not used for anything beyond conversion (backup tables, seed data, etc.  See below).

HTH,
Tanner

Name Type_Desc Type_Desc
CnvProgs_backup HEAP USER_TABLE
Menu_backup HEAP USER_TABLE
Security_backup HEAP USER_TABLE
Seed_BAQReport HEAP USER_TABLE
Seed_BAQRptFilter HEAP USER_TABLE
Seed_BAQRptOptionFld HEAP USER_TABLE
Seed_BAQRptSort HEAP USER_TABLE
Seed_BAQRptSortFld HEAP USER_TABLE
Seed_BpArgument HEAP USER_TABLE
Seed_BpHoldType HEAP USER_TABLE
Seed_BpMethod HEAP USER_TABLE
Seed_BpTextStorage HEAP USER_TABLE
Seed_CnvProgs HEAP USER_TABLE
Seed_ColumnAttribute HEAP USER_TABLE
Seed_DashBdBAQ HEAP USER_TABLE
Seed_DashBdChunk HEAP USER_TABLE
Seed_DashBdDef HEAP USER_TABLE
Seed_DashBdLike HEAP USER_TABLE
Seed_EFTHead HEAP USER_TABLE
Seed_ElementDetail HEAP USER_TABLE
Seed_ElementDisplayColumn HEAP USER_TABLE
Seed_ElementHeader HEAP USER_TABLE
Seed_ElementParameter HEAP USER_TABLE
Seed_ESSearch HEAP USER_TABLE
Seed_ExtSysTable HEAP USER_TABLE
Seed_IntParamDef HEAP USER_TABLE
Seed_LangName HEAP USER_TABLE
Seed_LangOrg HEAP USER_TABLE
Seed_LangProg HEAP USER_TABLE
Seed_LangTran HEAP USER_TABLE
Seed_LangXref HEAP USER_TABLE
Seed_MemoCatRelatedToTable HEAP USER_TABLE
Seed_Menu HEAP USER_TABLE
Seed_MenuProcess HEAP USER_TABLE
Seed_MrpProc HEAP USER_TABLE
Seed_MrpProcQueue HEAP USER_TABLE
Seed_MrpQueue HEAP USER_TABLE
Seed_PatchFld HEAP USER_TABLE
Seed_ProcessSet HEAP USER_TABLE
Seed_ProcessTask HEAP USER_TABLE
Seed_ProcessTaskParam HEAP USER_TABLE
Seed_PublishedView HEAP USER_TABLE
Seed_QueryCtrl HEAP USER_TABLE
Seed_QueryCtrlValues HEAP USER_TABLE
Seed_QueryCustomAction HEAP USER_TABLE
Seed_QueryDiagram HEAP USER_TABLE
Seed_QueryExecuteSetting HEAP USER_TABLE
Seed_QueryField HEAP USER_TABLE
Seed_QueryFunctionCall HEAP USER_TABLE
Seed_QueryGroupBy HEAP USER_TABLE
Seed_QueryHdr HEAP USER_TABLE
Seed_QueryParameter HEAP USER_TABLE
Seed_QueryRelation HEAP USER_TABLE
Seed_QueryRelationField HEAP USER_TABLE
Seed_QuerySortBy HEAP USER_TABLE
Seed_QuerySubQuery HEAP USER_TABLE
Seed_QueryTable HEAP USER_TABLE
Seed_QueryUpdateField HEAP USER_TABLE
Seed_QueryUpdateSettings HEAP USER_TABLE
Seed_QueryValueSetItems HEAP USER_TABLE
Seed_QueryWhereItem HEAP USER_TABLE
Seed_QuickSearch HEAP USER_TABLE
Seed_QuickSearchCriteria HEAP USER_TABLE
Seed_QuickSearchValueList HEAP USER_TABLE
Seed_Report HEAP USER_TABLE
Seed_ReportDefaultStyle HEAP USER_TABLE
Seed_ReportStyle HEAP USER_TABLE
Seed_ReportType HEAP USER_TABLE
Seed_RptCalcField HEAP USER_TABLE
Seed_RptDataDef HEAP USER_TABLE
Seed_RptDefault HEAP USER_TABLE
Seed_RptExclude HEAP USER_TABLE
Seed_RptLinkField HEAP USER_TABLE
Seed_RptLinkTable HEAP USER_TABLE
Seed_RptLiterals HEAP USER_TABLE
Seed_RptParms HEAP USER_TABLE
Seed_RptRelation HEAP USER_TABLE
Seed_RptRelationField HEAP USER_TABLE
Seed_RptStylePrinters HEAP USER_TABLE
Seed_RptTable HEAP USER_TABLE
Seed_RptWhereItem HEAP USER_TABLE
Seed_Security HEAP USER_TABLE
Seed_SolutionType HEAP USER_TABLE
Seed_SolutionTypeDetail HEAP USER_TABLE
Seed_TableAttribute HEAP USER_TABLE
Seed_Theme HEAP USER_TABLE
Seed_ThemeResource HEAP USER_TABLE
Seed_Tip HEAP USER_TABLE
Seed_UDCodes HEAP USER_TABLE
Seed_UDCodeType HEAP USER_TABLE
Seed_UDMap HEAP USER_TABLE
Seed_XXXChunk HEAP USER_TABLE
Seed_XXXDef HEAP USER_TABLE
Seed_ZBODataSets HEAP USER_TABLE
Seed_ZBODef HEAP USER_TABLE
Seed_ZColumnProperty HEAP USER_TABLE
Seed_ZDataField HEAP USER_TABLE
Seed_ZDataSet HEAP USER_TABLE
Seed_ZDataTable HEAP USER_TABLE
Seed_ZFieldDecimal HEAP USER_TABLE
Seed_ZKey HEAP USER_TABLE
Seed_ZKeyField HEAP USER_TABLE
Seed_ZLinkColumn HEAP USER_TABLE
Seed_ZLookupField HEAP USER_TABLE
Seed_ZLookupLink HEAP USER_TABLE
Seed_ZRelation HEAP USER_TABLE
Seed_ZRelationField HEAP USER_TABLE
Seed_ZSubDataSet HEAP USER_TABLE
Seed_ZSystem HEAP USER_TABLE
ttBpHoldType HEAP USER_TABLE
ttDashBdBAQ HEAP USER_TABLE
ttDashBdChunk HEAP USER_TABLE
ttDashBdDef HEAP USER_TABLE
ttDashBdLike HEAP USER_TABLE
ttEFTHead HEAP USER_TABLE
ttMrpProc HEAP USER_TABLE
ttMrpProcQueue HEAP USER_TABLE
ttMrpQueue HEAP USER_TABLE
ttQueryCtrl HEAP USER_TABLE
ttQueryCtrlValues HEAP USER_TABLE
ttQueryCustomAction HEAP USER_TABLE
ttQueryDiagram HEAP USER_TABLE
ttQueryExecuteSetting HEAP USER_TABLE
ttQueryField HEAP USER_TABLE
ttQueryFunctionCall HEAP USER_TABLE
ttQueryGroupBy HEAP USER_TABLE
ttQueryHdr HEAP USER_TABLE
ttQueryParameter HEAP USER_TABLE
ttQueryRelation HEAP USER_TABLE
ttQueryRelationField HEAP USER_TABLE
ttQuerySortBy HEAP USER_TABLE
ttQuerySubQuery HEAP USER_TABLE
ttQueryTable HEAP USER_TABLE
ttQueryUpdateField HEAP USER_TABLE
ttQueryUpdateSettings HEAP USER_TABLE
ttQueryValueSetItems HEAP USER_TABLE
ttQueryWhereItem HEAP USER_TABLE
ttQuickSearch HEAP USER_TABLE
ttQuickSearchCriteria HEAP USER_TABLE
ttQuickSearchValueList HEAP USER_TABLE
ZDataField_backup HEAP USER_TABLE
ZDataSet_backup HEAP USER_TABLE
ZDataTable_backup HEAP USER_TABLE
On Thu, 16 Jul 2015 20:17:30 -0500, s1mhall@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div id="ygrps-yiv-208063586ygrp-text">
  
  
  <p>Hello,<br>Can anyone on E10 tell me if all of the tables in the database have clustered indexes?<br><br>Thanks in advance<br><br>Simon Hall<br><br></p><p><span><br class="ygrps-yiv-208063586yui-cursor"></span></p>

</div>
 


<div style="color:#fff;height:0;"></div>



--
Using Opera's mail client: http://www.opera.com/mail/
Hello,
Can anyone on E10 tell me if all of the tables in the database have clustered indexes?

Thanks in advance

Simon Hall