seen from China
seen from Malaysia
seen from Türkiye
seen from Malaysia
seen from United States
seen from United States
seen from Mexico
seen from Germany
seen from China
seen from Türkiye
seen from Romania
seen from United States
seen from Pakistan
seen from China
seen from Switzerland
seen from Canada
seen from Malaysia
seen from Sweden
seen from Romania
seen from United States
Simple Way to Write DML SQL in DB2
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…
View On WordPress
5 More DB2 SQL Performance Tips
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…
View On WordPress
DB2 SQL- Rules for Creating Index
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…
View On WordPress
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
DB2-SQL Part-2
View On WordPress
