Loads by pass a few steps that typically a query would go through (a query GOES through plan generation, optimization and transaction management). Loads are done in terms of “sets” and this set is based on underlying table structure (thus loads for two different tables are different as their sets are based on table structures). Data is processed to check format and distribution of records calculated very QUICKLY (in one step), fills into ‘set’ structure and writes to storage structure. Storage ALSO PERFORMS space availability and other admin tasks, all these operations go pretty quick (think of them as UNIX named pipes that streams data and SPU STORES these records).

Loads by pass a few steps that typically a query would go through (a query goes through plan generation, optimization and transaction management). Loads are done in terms of “sets” and this set is based on underlying table structure (thus loads for two different tables are different as their sets are based on table structures). Data is processed to check format and distribution of records calculated very quickly (in one step), fills into ‘set’ structure and writes to storage structure. Storage also performs space availability and other admin tasks, all these operations go pretty quick (think of them as UNIX named pipes that streams data and SPU stores these records).