Chapter 6 – CTAS and CBT
“A different world can not be achieved through indifferent people.”
CTAS (Create Table AS)
Create Table AS (CTAS) is a way to create new tables from existing tables without the reloading data. The table create is based solely on query results. This is a brilliant way to place tables distribution keys in the order you want to performance tune queries.
Using the CTAS (Create Table AS) Table For Co-Location
Because both tables are joined on the key Customer_Number, and both tables are using Customer_Number ...