I’ve heard that SELECT * is generally bad practice to use when writing SQL commands because it is more efficient to SELECT columns you specifically need. If I need to SELECT every column in a table, should I use SELECT * FROM TABLE or SELECT column1, colum2, column3, etc. FROM TABLE ?

Hi @ivan_s , As a general rule of thumb, it is better to avoid scanning all columns of the table and instead just scan the columns that your application needs (using SELECT column1, column2..), for better query performance. Additionally, it also makes sure that your application is not impacted if t…

Which is faster/best? SELECT * or SELECT column1, colum2, column3, etc

General

dorian_yugabyte March 12, 2020, 3:39pm 4

By optimize you mean you don’t need all columns ?
If you don’t, then request only those that you need.

Topic		Replies	Views
Why INSERT query is slower than SELECT query? General	14	715	January 22, 2022
Performance of IN clause in select query General	2	36	October 29, 2024
Secondary Index and Select General	7	1570	April 13, 2018
Issue with views General	1	591	January 14, 2023
Optimizing Query Performance in YugabyteDB! General	2	74	January 29, 2025

Which is faster/best? SELECT * or SELECT column1, colum2, column3, etc

Related topics