Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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
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.