Search found 9 matches
- Sat Mar 07, 2015 3:08 pm
- Forum: Vertica Data Load
- Topic: Data in WOS
- Replies: 6
- Views: 22403
Data in WOS
In WOS, do we have records of the table for all table's projections. If I have Super projection for a table and user defined projections [ie with only few columns] then inserting a record into table will have records for super projection and user defined projection in main memory or the data will be...
- Sat Mar 07, 2015 3:02 pm
- Forum: Vertica Data Load
- Topic: What Happens when using Direct Option in Copy , Insert, Update Command
- Replies: 1
- Views: 13425
What Happens when using Direct Option in Copy , Insert, Update Command
In Document it says Direct options allows data to be moved directly to WOS [ Secondary storage]. But How does it happen during processing. Sorry if I am wrong, According to the computer knowledge I have gained, the data cannot directly move to harddisk without passing main memory. If that is the cas...