[MBCook]

Plus read-only isn't a guarantee. You can't write data, but you can run a bad select or join that ends up effectively locking the database.

SELECT * FROM my_200_GB_table will always be there.

[michaelt]

Why should a select or join lock a database? Surely no database lets one query starve another of IO or CPU?