Hi,
I have run the index tuning wizard against a work load, and it has reported back with recomendations for indexes and views, which I have scripted out.
Now having looked at the script the indexes and views have numbers against the names. I have changed the names of for the indexes but I'm not sure about the views. Can I change the names of the views? if I do so how will the orginal quiery know which view to use? or am I missing something?
Any help will be greatly appriociated.
Thanks
Shiraz