CQE-9175: Excessive Number of Indices for a Large Data Table

 
Excessive Number of Indices for a Large Data Table
[an error occurred while processing this directive] Definition in a New Window Definition in a New Window
Quality Issue ID: 9175 Maturity: Preliminary
+ Description

Description Summary

The software uses a data table that contains a large number of indices.

Extended Description

This pattern identifies situations where the data table is considered as very large, based on its number of rows which exceeds the threshold value, and is considered to have too many indices, based on its number of indices which exceeds the threshold value. The default value for number of rows is 1000000. The default value for number of indices is 3.

+ Relationships
NatureTypeIDNameView(s) this relationship pertains to
View
ChildOf
Pr
Practice		9105Data Access Constructs
Quality Issues Organized by Practices (primary)9002
ChildOf
Ch
Characteristic		9169Performance
Default Graph (primary)9001
CanPrecede
Co
Consequence		9039Excessive Resource Expenditure
Default Graph (primary)9001

Related Taxonomy Entries

TaxonomyVersionRelated ID
ASCPEM1ASCPEM-PRF-6
+ References
"Automated Source Code Performance Efficiency Measure (ASCPEM)". ASCPEM-PRF-6. v1.0. Object Management Group (OMG). 2016-01-01. <http://www.omg.org/spec/ASCPEM/1.0>.
Page Last Updated or Reviewed: October 01, 2017