OiO.lk Blog SQL Subquery of select * vs Subquery of select fields
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

Exit mobile version