select * from tables or from view?

[adonet]

I have two store procedures, which one is better?

1) select * from many tables, add joining, where clause, order by...
2) create a view in which get the same tables, add joining, where clause, order by..., and then create a store procedure, select * from view.

The only thing I concerned is the speed. Which store procedure is fast?

 

[hmckillop]

depends, if you have small real-time updates and if its an indexed view, you can have significant performance gains using a view.



"I'm living so far beyond my income that we may almost be said to be living apart

 

[SQLSister]

If it is not an indexed view, then using a view will slow things down as will using select *.

Questions about posting. See faq183-874