February 12, 2007 at 7:15 pm
Hi, I'm having a problem with index creation on view. I have a huge table, let's call it table apple in database name cat which is having transactional replicated from our central server to site server. table apple has index created in central server. Question, I need a view of table apple created in another database name dog in replicated server (that's mean I have database cat (replicated) and dog). Because of this is a huge table, how can I fine tune this view when retrieving data from it? I'm not able to create index in this view because the view is not with schema bounded. Any advise on how to deal with it? Thanks!
February 13, 2007 at 2:49 pm
Alicia,
Indexed view is like a table, data are stored in the database as a clustered index and indexed views are not well suited for the data that are frequently updated. Do you think that because the data will be stored in the database anyway with indexed view, you may just want to copy the table to dog database and refresh it as needed?
Regards,Yelena Varsha
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply