lock on TABLE

Database
N/A

lock on TABLE

f I run SELECT on a table vs SELECT on a view which references that table, is the LOCK on the underlying table going to behave differently?

1 REPLY
N/A

Re: lock on TABLE

No.
But the view could have a Locking For Access clause which allows a dirty read on anything accessing the table via the view.