Need input : How to avoid dirty read without waiting for the table to be refreshed

General
Enthusiast

Re: Need input : How to avoid dirty read without waiting for the table to be refreshed

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.