Did You Know…This About CTAS vs. SELECT…INTO

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

Leave a Reply