Select * from table - Detriment to performance

ColCode
Level 1
Select * from table - Detriment to performance

Hi

What is the impact on performance when you use 'Select * from table' instead of naming the actual columns.

If you use SQL Server or Oracle its best practice to name the individual columns.

Is there a big detriment to performance if you dont individually name the columns

Cheers

0 Kudos
1 Reply
AlexT
Dataiker

Hi,

There is a good thread explaining select * vs select column1,column2 here which you may find helpful

https://stackoverflow.com/questions/3180375/select-vs-select-column

It's difficult to quantify the impact on performance as it will vary depending on your database, how often you query the database etc. with SELECT * but as you suggest it's best practice and should avoid SELECT * where possible. 

0 Kudos