Home

Large item lists should not be used with IN clauses

Rule description

  • Large item lists should not be used with IN clauses

 

Compliant Code Example

SELECT
    NAME,
    ADDRESS,
    CREDIT_LIMIT
FROM
    CUSTOMERS
Where CREDIT_LIMIT IN (900,1000,1100,1200,1300,1400,1500,1600,1700,1800,1900); --Compliant code (IN clause is having less number of items than the default defined 1000 items)
Visual Expert 2020
 VEPLSQLRULE84