I am using a reporting database which for all practical purposes is a read only database. It is created data and dynamic reports are generated and viewed on this database. I was thinking of making this database as read-only.
Some of things I want to ask regarding read-only databases are
- Is only the data read only ? Can we still create indexes or views on this database ?
- What are the performace benefits of using a read-only database ? like, select queries using shared locks ..
- Is there any disadvantage of using a read-only database ?
- Any best practicse while using read-only reporting database.
Please let me know, if you need any more information.