Planet DB2
  • About
  • Submit Your Blog
  • Contact Us
Select Page

Comparing Db2 and MySQL: Explain

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

Comparing Db2 and MySQL: NULL in Indexes

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...

Recent Posts

  • MySQL’s “partial” Group By
  • The DB2Night Show Episode #Z133: A Row’s Life
  • Using ChatGPT to Write SQL
  • New IBM Internship Opportunities for Canadian Students
  • Escaping Single Quotes in Db2 SQL Statements

Recent Comments

    Copyright 2020 Planet DB2
    ×

    Submit Your Blog