Home

Rule description

• SELECT statements used as argument of EXISTS statements should be selective

Non-compliant Code Example

SELECT 
    NAME,
    ADDRESS,
    CREDIT_LIMIT       
FROM
    CUSTOMERS
WHERE EXISTS (SELECT NAME FROM VENDOR);             --Non compliant code (SELECT statements used as argument of EXISTS statements is not selective)

Compliant Code Example

SELECT 
    NAME,
    ADDRESS,
    CREDIT_LIMIT       
FROM
    CUSTOMERS
WHERE EXISTS (SELECT NAME FROM VENDOR WHERE NAME IS NOT NULL);  --Compliant code (SELECT statements used as argument of EXISTS statements is selective)