79097838

Date: 2024-10-17 11:27:29
Score: 2
Natty:
Report link

Snowflake uses Columnar storage. So, selecting all columns from a table of 50 columns is going to be far more I/O intensive than selecting two columns.

So, based on the limited context you have provided, the 2nd option is better i.e. select col1, col2 from (select col1, col2 from tablea /AdditionalLogc/)

Reasons:
  • Low length (0.5):
  • No code block (0.5):
  • Low reputation (1):
Posted by: Suraj Ganiga