#db2 sql checklist

DB2- How to write Best SQL Queries

Teradata Jobs

The following SQL checklist will help to review SQL Queries.

Check for by mistake any inner join is coded as outer-join

Check all union statements, is it really needed, or we can go with UNION ALL

Check for NULLABLE columns, if NULL value comes, we need to handle -305 errors

Check for Select statement, is all the columns absolutely needed

Check for ALL aggregate functions, handling…