#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/