by Ember Crooks | Nov 8, 2022 | DB2, Db2vsMySQL, Explains, Featured, mysql, sql
The goal of this article is to to take one query and use the explain facilities of Db2 to walk through it, and then do the same with MySQL, and then show some of the optimizations I might make for the query and why.… Read the rest
by Henrik Loeser (data_henrik) | Nov 7, 2022 | conference, DB2, dedug, fun, IBM, idug, IT, user group
"IDUG 2023 EMEA will be in"The IDUG 2022 EMEA Db2 Tech Conference is over. What a week it was! Hard work, not much sleep, technical education, in-person networking, fun, and much more. After getting home, I needed two days and especially the nights to recharge, then...
by Ember Crooks | Nov 3, 2022 | DB2, Db2vsMySQL, Explains, Featured, mysql
I’ve been spending some time working with indexes as I learn MySQL, and there were a few things I thought were were worth mentioning. As always, I’m writing from my own knowledge with deep experience in IBM DB2, and as a learner when it comes to...
by Ember Crooks | Oct 27, 2022 | DB2, Db2vsMySQL, Featured, mysql
I’ve spent some time understanding how MySQL structures tables and indexes, and wanted to share what I’ve learned. This is not the structure as created in the CREATE TABLE or CREATE INDEX statements, but how that data is generally structured on disk, both...
by Henrik Loeser (data_henrik) | Oct 25, 2022 | administration, DB2, IBM, IT, json, security
JSON Web Token support in Db2Right now, I am at the IDUG 2022 EMEA Db2 Tech Conference in Edinburgh, Scotland. It's great to have an in-person event again, to network and to discuss. This year, there are many sessions covering Db2 security and they are well-attended....
by Ember Crooks | Sep 8, 2022 | DB2, mysql, RDBMS, rdbms concepts
One of the things that learning a new RDBMS is teaching me is that there are some concepts that are common to RDBMSes. It is helping me to identify some of those concepts, and I learn a lot from the similarities and differences.… Read the rest
Recent Comments