Indexed view

  • Hi

    I have a table which is large and we just need the last 2 month of data.I want to archive the old data in another database and create a view of this table in main database.

    Now the question :Is the indexes of table enough or we should create indexes on view in main database?

  • 1. Technically, it is not an indexed view until you create an Clustered Unique Index on the view. So you do need atleast the Clustered Unique index to call it an indexed view.

    2. Beyond that, any indexing requirements are best answered by your needs. I dont think a person not familiar with your database or app can answer that part. Look up some general guidelines on what indexes need to be created. Or read more into them here (http://www.sqlservercentral.com/stairway/72399/)

    3. Finally, I dont think cross database indexed views are possible.

  • Thanks a lot

    Yes according to your comments I try to create clustered index but I can not use with schema binding cross database 🙁

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply