This post is a part of the series “Did You Know” whereby the purpose is to share some quick key point of a particular concept that helps us to be informed on top of our head or something that we want to be revisited quickly. So, no detailed discussions on the topic but a straight finding about it in a line or two.
CTAS is a kind of SELECT…INTO statement to create new table where you can specify both the distribution of the table and the table structure type whereas SELECT…INTO creates a new table by using the default distribution type of ROUND_ROBIN and the default table structure of CLUSTERED COLUMNSTORE INDEX