Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kingroon
Starting Member
29 Posts |
 Posted - 2011-04-27 : 09:35:54
|
| G'day..Not really a case specific question, but more a general performance query!If I have a VIEW looking at 4 or 5 "denormalised" TABLEs in my SQL2000 DB, and shortly before selecting from the VIEW each day I DROP and reCREATE one of those TABLES [namely the largest at 27m rows], is the "Execution Plan/Path" of the VIEW rebuilt?Hasta Luego..KingRoonhttp://www.dogfightclothing.com |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2011-05-02 : 07:54:17
|
| On every schema change, cached plan for said view will become invalid and will be generated from scratch by query optimizer.--------------------------http://connectsql.blogspot.com/ |
 |
|
|
|
|
|
VIEWs, Execution Plans & DROPped TABLES