read-only database index
1 Topic
Is it possible to add an index to a read-only database?
I was given a read-only (daily log shipped) copy of our production database (updated daily) to do some special reporting and the report needs to be optimized with a new index. However because the database is read-only I cannot add an index. From the information I have been given they are telling me to add that index to the production database and it will port over. Since this is a production database, I can't so easily do a change like that without getting approvals from the vendor and dba etc. which could be a long time. Can I make that database writeable and add the index with a job perhaps and set it back? Any other workarounds or thoughts would be greatly appreciated!!Solved4.4KViews0likes1Comment