Database Administrators
Profile Activity
Meta user
Network profile
19,513
reputation
2
21
54

Lennart

Spend most of my time in a db2 environment as a DA/DBA. From time to time I also work with other DBMS such as mysql, psql, mssql.

I have a couple of Db2-utilities at github, that you may or may not find useful:

https://github.com/lelle1234/Db2Utils/

  • DBParser, creates ddl for a database. Output is supposed to be in topological order

  • IndexAdvisor, investigates all possible index combinations for a query

786
answers
41
questions
~1.8m
people reached
  • Umea, Sweden
  • lelle1234
  • dustbite.se
  • Member for 6 years, 9 months
  • 1,173 profile views
  • Last seen 4 hours ago

Communities (24)

Top network posts

Top tags (261)

Score 404
Posts 276
Posts % 33
Score 316
Posts 118
Score 235
Posts 151
Score 121
Posts 68
Score 97
Posts 59
Score 88
Posts 49
View all tags →

Top posts (827)

All Questions Answers
Votes Newest
47 NOT (a=1 AND b=1) vs (a<>1 AND b<>1) Apr 6 '17
27 If a database only ever has one insert, is it bad to index every possible column combination? Jun 13 '18
14 Does `COUNT` discard duplicates? Aug 2 '17
12 Does the spec permit column-count mismatch on INSERT? Jan 19 '18
12 What is the optimized way to pass multiple parameter from a single table to a function? Jan 19 '18
10 How to use select (query)alias on WHERE clause? Apr 20 '18
10 MariaDB: disable foreign key checks Aug 10 '16
10 Avoiding a divide by zero error in a computed column Jan 6 '16
9 Should the referencing table have primary key, auto increment, or index? Nov 3 '18
9 slow select query on datetime column Jan 10 '16
View all questions and answers →

Badges (77)

Gold

2

Rarest

Silver

21

Rarest

Bronze

54

Rarest

View all badges →

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.