Database Blobs && Performance

Hi geniuses,



I have a core database question in MS Access and SQL Server.



Assume the following table in MS Access or SQL Server:

Employees table:

EmpID, Name, Hiredate, Photo;



and the following query:

"SELECT EmpID, Name, Hiredate FROM Employees;"



The question is, "does the blob object (Photo) affect the performance of the query even when not included in the select statement?"

I mean, will I gain some additional performance when separating the blob fields to another table?



Thanks for the answer.