Is it possible to add an index to a read-only database?

%3CLINGO-SUB%20id%3D%22lingo-sub-1252343%22%20slang%3D%22en-US%22%3EIs%20it%20possible%20to%20add%20an%20index%20to%20a%20read-only%20database%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1252343%22%20slang%3D%22en-US%22%3E%3CP%3EI%20was%20given%20a%20read-only%20(daily%20log%20shipped)%20copy%20of%20our%20production%20database%20(updated%20daily)%26nbsp%3Bto%20do%20some%20special%20reporting%20and%20the%20report%20needs%20to%20be%20optimized%20with%20a%20new%20index.%20However%20because%20the%20database%20is%20read-only%20I%20cannot%20add%20an%20index.%20From%20the%20information%20I%20have%20been%20given%20they%20are%20telling%20me%20to%20add%20that%20index%20to%20the%20production%20database%20and%20it%20will%20port%20over.%20Since%20this%20is%20a%20production%20database%2C%20I%26nbsp%3Bcan't%20so%20easily%20do%20a%20change%20like%20that%20without%20getting%20approvals%20from%20the%20vendor%20and%20dba%20etc.%20which%20could%20be%20a%20long%20time.%20Can%20I%20make%20that%20database%20writeable%20and%20add%20the%20index%20with%20a%20job%20perhaps%20and%20set%20it%20back%3F%20Any%20other%20workarounds%20or%20thoughts%20would%20be%20greatly%20appreciated!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1252343%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eread-only%20database%20index%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1300152%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20it%20possible%20to%20add%20an%20index%20to%20a%20read-only%20database%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1300152%22%20slang%3D%22en-US%22%3ESimply%20it%20is%20not%20possible%20to%20make%20indexes%20on%20read-only%20database.%3CBR%20%2F%3EBecause%20it%20is%20read-only%20as%20it%20named%2C%20a%20writable%20operation%20is%20not%20a%20selectable%20option.%3CBR%20%2F%3E%3CBR%20%2F%3Esimple%20work-around%20is%20that%20you%20restore%20one%20more%20database%20for%20a%20report%20and%20use%20it%20for%20other%20report%20too%2C%20of-course%20reported%20data%20is%20only%20point-in-time%20of%20recovered%20time.%3CBR%20%2F%3E%3CBR%20%2F%3Eand%20for%20original%20daily%20log-shipped%20database%20just%20don't%20touch%20it%20unless%20you%20can't%20make%20maintenance%20time%20for%20creating%20index.%3C%2FLINGO-BODY%3E
Occasional Contributor

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!!

1 Reply
Simply it is not possible to make indexes on read-only database.
Because it is read-only as it named, a writable operation is not a selectable option.

simple work-around is that you restore one more database for a report and use it for other report too, of-course reported data is only point-in-time of recovered time.

and for original daily log-shipped database just don't touch it unless you can't make maintenance time for creating index.