October 17, 2014 at 7:21 am
Hi,
will it update view when ever underlying tables insert,update and delete records will have any performance issue.
--chalam
October 17, 2014 at 7:24 am
Views are just saved select statements. They have no data storage.
When you query a view, all SQL does is query the tables that the view references to get the data that you want.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 17, 2014 at 7:45 am
chalam87 (10/17/2014)
will it update view when ever underlying tables insert,update and delete records will have any performance issue.
Is it an indexed view?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply