Press "Enter" to skip to content

Abnormal Tables and Skewed Data

Erik Darling reminds us to be vigilant in database design:

But the Posts table suffers from a serious design flaw in the public data dump: Questions and Answers are in the same table.

I’ve heard that it’s worse behind the scenes, but I don’t have any additional details on that.

Read on to understand why this is a problem and what the ramifications are.