DB2 : Cost Calculation 3 : index only revisited
Index Why In the DB2 : Cost Calculation 2 : index only post I noticed something upsetting, well, at least […]
Cost, DB2, Explain, SQL
DB2
Cost, DB2, Explain, Index
DB2 Cost : index of articles
I started a series of articles concerning the cost of queries (and as a consequence concerning the choices the optimizer […]
Cost, DB2, Index
DB2 : Cost Calculation 2 : index only
Index Why indexes Searching through millions of rows can be the right thing to do (TBSCAN). It might be the […]
Cost, DB2
DB 2 : Cost calculations 1 : Table Scan
Index Why? When you supply DB2 with a query DB2 has to make some serious decisions: – Should indexes be […]
DB2, Explain
DB2 Explain plan doesn’t exists
Just a quick reminder: If you start a new database where you want to genrate some execution-plans you might run […]
DB2, SQL
DB2 Row generator
Sometimes you need a mechanism to generate rows. For example when you need to create a demonstration table . Recursive […]
Backup, DB2
Basic Backups with DB2
Introduction To me the most important thing as a DBA is making sure the data in a database is safe. […]
DB2
DB2 commands
Starting the database [db2inst1@bloemkool ~]$ db2start 01/11/2022 14:57:48 0 0 SQL1063N DB2START processing was successful. SQL1063N DB2START processing was successful. […]
DB2, SQL
Recursive SQL in DB2
Problem Playing around in DB2 I wanted to know how to create a hiearchical query. This because I wanted to […]