Select * from table - Detriment to performance
ColCode
Registered Posts: 1 ✭✭✭
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
Tagged:
Answers
-
Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,226 DataikerHi,
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.