October 21, 2024
Chicago 12, Melborne City, USA
SQL

Subquery of select * vs Subquery of select fields


Need help in understanding which of the following snowflake SQL is faster and why. provided tablea has 50 columns. Or do You think both are equally efficient.

select col1, col2 from (select * from tablea /*AdditionalLogc*/))
--Vs
select col1, col2 from (select col1, col2 from  tablea /*AdditionalLogc*/))



You need to sign in to view this answers

Leave feedback about this

  • Quality
  • Price
  • Service

PROS

+
Add Field

CONS

+
Add Field
Choose Image
Choose Video