Forum Discussion
Calling views or stored procedures
Hello, When importing data using the refresh schedule on the Report Server - is there a performance difference between calling a view or executing a stored procedure? What about if it's being ref...
Hi,
both methods create a execution plan on the SQL Server. You must beware of parameter sniffing by SP.
But in my mind there is no opposite on the performance. But I prefer Views, these are gives me a better handling on the filtering