4 ms·
I was expecting a punch line on that comic strip. nothin. Regarding the "Always Load Sorted Data" section, it says to insert the data into the table so that th
by devmunchies 6y ago
I was expecting a punch line on that comic strip. nothin.
Regarding the "Always Load Sorted Data" section, it says to insert the data into the table so that the column you want to select on is already sorted, thus having a correlation of 1.
What if I'm adding a single record to the database, how do you re-sort them all upon insert?
- deleted 6y ago[deleted]
- gmfawcett 6y agoBy "load" I'm pretty sure they mean "insert initial data into an empty table." So a different use case. In ETL work, for example, it's not uncommon to truncate and reload source and staging tables on each batch run. So the tip would be helpful in those scenarios, more than in an OLTP case (insert this record, update that one).