Chapter 6 – CTAS and CBT

“A different world can not be achieved through indifferent people.”

Chinese Proverb

 

CTAS (Create Table AS)

image

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

image

Because both tables are joined on the key Customer_Number, and both tables are using Customer_Number ...

Get The Brilliance of Netezza now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.