Depends on your database. Oracle only loads the entries that it actually shows. Same for Snowflake.

Don’t use Select *: Select * outputs all the columns of a data table, it is an expensive operation and increases the execution time of the query. The ideal way is to select only the relevant columns…
5 Most Common SQL mistakes you should avoid
253
7
Anmol Tomar
Chris So
·Follow
May 13, 2022
--
Depends on your database. Oracle only loads the entries that it actually shows. Same for Snowflake.
--
--
Written by Chris So39 Followers
·61 Following
Data Dude and SQL enthusiast. Occasionally does Pixel art◾
No responses yet
Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams