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 |
|
rythm123us
Starting Member
27 Posts |
 Posted - 2005-10-16 : 12:57:21
|
| 1) I have noticed that anytime I make any chnage to my Indexed View (Adding a column or Renaming a Colum) the Index disappears. I have to create the index again. Is this default behavior or am I doing something wrong. Everything works fine, but I just want to avoid writing the same Index again.2) The index only seems to work when I use "WEITH(NOEXPAND)". Is it ok to use this hint all the time and leave it in a Stored Procedure or another regular view.Thanks in advance. Any advice would be appreciated.--rythm |
|
|
|
|
|
INDEXED VIEWS Questions