|
rythm123us
Starting Member
27 Posts |
 Posted - 10/16/2005 : 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
