Hi,
When i use a view inside my stored procedure, it takes a longer time to execute. This view has a select statement from a different database. i.e., select columnname from [dbx].dbo.table1
However, if i give the select statement directly instead of a view inside the stored proc, it executes faster than the former.
Can anyone please let me know why?
Thanks.
C.Ganesh