#db2 sql

Simple Way to Write DML SQL in DB2

Start Your Career SQL-n-PLSQL

DML – Data manipulation language commands.

S-I-D-U (The way we can remember as Cricketer name)

SELECT

All queries begin with the SELECT SQL statement, which is an extremely powerful statement that is used to construct a wide variety of queries containing an infinite number of variations (using a finite set of rules). And because the SELECT statement is recursive, a…

5 More DB2 SQL Performance Tips

START Analytics Career

SELECT from INSERT, UPDATE whenever possible.  This feature is great for getting the values associated with identity, sequence, and any other database column keys while doing an INSERT or UPDATE SQL operation. This capability provides for the capturing of generated key values needed to be returned to the application during an UPDATE or INSERT statement.  Instead of executing…

DB2 SQL- Rules for Creating Index

Indexes will speed-up the performance. Before creating Indexs, the following rules can be considered.

Consider indexing on columns used in WHERE, GROUP BY, and ORDER BY clauses, as well as for UNION, INTERSECT, and EXCEPT statements.

Limit the indexing of very frequently updated columns.

If indexing an APPEND NO table without a hash, explicitly create a clustering index. Failure to do so will…

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…