|
Posted by Peter on 04/16/06 01:22
People are telling me it is bad to put
select * from <atable>
in a view. I better should list all fields of the table inside the
definition of the view.
I dont know exactly why but some say:
A select * from makes sql server does a table scan.
Is that true, even if i put a where on the select on the view? And what if i
dont list all fields in the select on the view?
Thanks for the answer.
Peter
Navigation:
[Reply to this message]
|