Forum Discussion

ctech1320's avatar
ctech1320
Copper Contributor
May 25, 2023
Solved

CTAS against external table running EXTREMELY slow

I have two tables of similar size (5 GB each) sitting in 120 (60 files for each table) parquet.snappy files in a storage account.   I can create an external table against both of these, however, wh...
  • ctech1320's avatar
    ctech1320
    May 25, 2023

    ctech1320 - I changed the CLUSTERED COLUMNSTORE INDEX to CLUSTERED INDEX([CustomerID]) and it ran in 15 minutes.  I think that was it.

ctech1320's avatar
ctech1320
Copper Contributor
May 25, 2023

ctech1320 - I changed the CLUSTERED COLUMNSTORE INDEX to CLUSTERED INDEX([CustomerID]) and it ran in 15 minutes.  I think that was it.

Resources