I was told from a SQL-DBA that there is a huge gap in performance between these statements, both statements are called from a stored procedure:
-- Procedure that select from table directly
Select * From [Table] Where condition
-- Procedure that select from a view
Select * From [View] Where condition
The SQL-DBA told me that selection from table is faster because when you select from a View, all data will be selected first then filtered, but from table it will apply filtration directly. I am a developer and I don't have much knowledge in database so I was hoping for some expert to advice me in this matter.
Upon answering this question, I think I will be able to know weather using Views is a best practice or not.