1 of 1 people found this helpful
Indexes in Orion use SQL’s default locking options, which is to allow both page and row level locks. SQL’s query planner chooses the appropriate lock level according to the operation being executed. If you disable page level locks, you force it to always use row level locks. This has two effects
- Index reorganization is impossible
- Complex performance tradeoffs – page level locks exist because they are more efficient for some operations/situations than row level locks
Disabling page locking for all tables would be very bad idea.