So when REPLACE VIEW has taken exclusive rowHash lock on the dictionary, does it lock underlying table? Ex:
1. Consider view is pointing to Table A
2. Run Macro to REPLACE VIEW to point to Table B. Will Table A have exclusive lock now becuase current view is pointing to Table A ?
Do you think we will have deadlock situation at all going with View switch approach for dirty read?
Thanks for your inputs.