I have a complex select query and a huge table.
I'm running this select statement, meanwhile an Update statement arrives and tries to update the table.
IMHO - update requires an exclusive lock - so the update statement will have to wait till the select command is finished.
Am I right ?
what can I do in order to: execute the complex
select, and also let theupdatecommand run (currently I don't care about dirty data)