How Check Constraints MIGHT Improve Your Queries and Missing Index Requests

[Vadik]

Интересный пост, не совсем про Аксапту, но возможно кому-то пригодится

Цитата:

Say you’ve got an app that’s designed to store multiple companies in a single database – but you don’t actually use it that way. All of the data in a given database is actually for the same company
..
All of our app’s queries have CompanyCode in their WHERE clauses – even though that doesn’t really do any filtering, but the app is a 3rd party app that always filters for just the company you’re logged into