ALLOW_PAGE_LOCKS option for Index...how does it work?

So 开发者_开发技巧if you have an index (Index1) with the ALLOW_PAGE_LOCKS options set to ON on Table1. Would it be possible that data on Table2 will not be accessible because Table1 & Table2 have data on the same page(s) that are being locked while Index1 is being used?

No, pages are not shared across tables

There are mix extents...

Mixed extents are shared by up to eight objects. Each of the eight pages in the extent can be owned by a different object.

This however doesn't matter for this