5 events
when toggle format what by license comment
May 28 '14 at 15:55 comment added Dave.Gugg The only performance issue would be the plan being dropped from the cache. That's probably going to happen either way if 20 fields are being added to the view. The permissions I wasn't aware of, so thanks for pointing that out!
May 28 '14 at 15:50 history migrated from stackoverflow.com (revisions)
May 28 '14 at 15:48 comment added Aaron Bertrand I don't know how that affects performance directly - if anything, queries against the new copy of the view will likely be more optimal, since they will be based on the current state of the underlying objects. More importantly, dropping the view and re-creating it will blow away any permissions applied to it...
May 28 '14 at 15:43 comment added Dhaval well never give this suggestion .. when you recreates view it will effect the view performance too.
May 28 '14 at 15:38 history answered Dave.Gugg CC BY-SA 3.0