CODEWITHSUNDEEP
sqlsql-servert-sqlindexing
Chinesinho
Chinesinho

Reputation: 1

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?

Upvotes: 0

Views: 783

Answers (1)

SQLMenace
SQLMenace

Reputation: 135021

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

Upvotes: 1

Related Questions