DB2- How to write Best SQL Queries
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…
View On WordPress














