3 ms·
Not accurate, you don't need to get all the columns, actually you don't need to operate over all the values of the column. If the data oes not change frequently
by jorgeleo 15y ago
Not accurate, you don't need to get all the columns, actually you don't need to operate over all the values of the column. If the data oes not change frequently, then column oriented is faster. The trade off is how many structures needed to be maintained when rows updates... Then row oriented is faster.