Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Query Speed

Author  Topic  Andy Starting Member 6 Posts Posted - 2001-02-14 : 19:20:34 Is there any speed difference in naming the fields you want from a table and getting all the fields with *? eg SELECT ID,Description,Value FROM Table WHERE Tag = 1 SELECT * FROM Table WHERE Tag = 1 By naming the fields i can get the data without the extra tag field which i already know because i passed it in. Which saves a little bit of memory depending on the number of fields i miss out. But if i'm also getting a speed drop in naming the fields instead of using * is it worth it.