Tag: Database
-
Row store vs Column store
Row Column “select *” run faster “select *” run slower as need to combine data Seek slower if not index. Traverse to block row 3, read all column until R3C5 (5 steps) Seek faster. Traverse to block column 5, read until R3C5 (3 steps) Aggregation slow, whole row of data is read out to memory…
Kim 2 ML 