CWE-1049

Excessive Data Query Operations in a Large Data Table
AI Translation Available

The product performs a data query with a large number of joins
and sub-queries on a large data table.

Status
incomplete
Abstraction
base

While the interpretation of 'large data table' and 'large number of joins or sub-queries' may vary for each product or developer, CISQ recommends a default of 1 million rows for a 'large' data table, a default minimum of 5 joins, and a default minimum of 3 sub-queries.

Common Consequences

other
Impacts
reduce performance

Potential Mitigations