Skip to main content
Database Administrators
Lennart - Slava Ukraini's user avatar
Lennart - Slava Ukraini's user avatar
Lennart - Slava Ukraini's user avatar
Lennart - Slava Ukraini
  • Member for 10 years, 6 months
  • Last seen this week
Profile Activity
Stats
23,620
reputation
3.7m
reached
909
answers
51
questions
Communities
View all
About

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

Badges
View all badges
3
gold badges
33
silver badges
71
bronze badges
Top tags
View all tags
485
Score
307
Posts
32
Posts %
383
Score
140
Posts
15
Posts %
312
Score
186
Posts
19
Posts %
136
Score
75
Posts
8
Posts %
102
Score
60
Posts
6
Posts %
97
Score
55
Posts
6
Posts %
Top posts
View all questions and answers
answer
47
NOT (a=1 AND b=1) vs (a<>1 AND b<>1)
Apr 6, 2017
answer
27
If a database only ever has one insert, is it bad to index every possible column combination?
Jun 13, 2018
answer
17
MariaDB: disable foreign key checks
Aug 10, 2016
answer
14
What is the optimized way to pass multiple parameter from a single table to a function?
Jan 19, 2018
answer
14
Does `COUNT` discard duplicates?
Aug 2, 2017
answer
13
SQLite - How does Count work without GROUP BY?
Nov 15, 2022
answer
12
Is an invalid date considered the same as a NULL value?
Aug 14
answer
12
Select only those records that have different/multiple values for a particular column
Jul 25, 2015
answer
12
How to use select (query)alias on WHERE clause?
Apr 20, 2018
answer
12
Does the spec permit column-count mismatch on INSERT?
Jan 19, 2018
Top network posts
View all network posts
49
MySQL : isn't in GROUP BY
31
Postgres Aggregating conditional sum
13
How to order the fields getting aggregated by XMLAGG function?
11
Left join with where clause for right table (Must return NULL from right) - Oracle
11
SQL version of VLOOKUP