Submit your innovative use case or inspiring success story to the 2023 Dataiku Frontrunner Awards! LET'S GO

Select * from table - Detriment to performance

Level 1
Select * from table - Detriment to performance


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


0 Kudos
1 Reply


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

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


Labels (1)
A banner prompting to get Dataiku