3 ms·

OLTP tables typically are normalized. But OLAP tables (data lake/warehouse stuff), for speed purposes, are intentionally denormalized and yes, you can have 100

by xarope 7mo ago

OLTP tables typically are normalized. But OLAP tables (data lake/warehouse stuff), for speed purposes, are intentionally denormalized and yes, you can have 100+ columns of nullable stuff.