True or False: a table with large records (rows) due to lots of fields (columns) will take longer to return a SQL query?
That is, if I have a SELECT ... WHERE...query in SQL that operates on a table that has many fields, and hence lots of big data heavy rows, this SQL query will be significantly slower or slower than the same SELECT/WHERE Sql query that operates on a table having fewer fields?
I want a definite answer. None of this "it all depends, why don't you test it and see" stuff either. ;-) I say it makes no difference unless you pick some absurd number close to the maximum number of fields you can support in a record. Target is SQL Server 2008. Thanks.
EDIT: What I am saying is a table with fields "GUID", "NAME", "ADDRESS"...and 50 other parameters will take longer to return a SELECT/WHERE query against a second table having only "GUID" and "NAME", with the WHERE of course being '= NAME' (and the same raw number of rows, let's say both have 10000 rows in the table).