Inside Microsoft® SQL Server™ 2005

Conclusion

Views give you great power. They give you some degree of security enforcement, allow you to develop simpler solutions in a modular approach, and can help you improve the performance of your queries when you index them. Keep in mind that a view represents a table and, as such, does not have any guaranteed order to its rows. Do not attempt to produce a "sorted" view because the entire premise for adopting such an approach is wrong. If you need to send data from a view to the client in a particular order, specify an ORDER BY clause in the outer query. Remember to refresh views’ metadata information after applying schema changes to underlying objects in the database.