A different approach to query optimization is based on constraints specified on the
database schema to reduce the search space. This approach, known as semantic query
optimization, may be used in conjunction with the techniques discussed above. For example, in Section 6.2.5 we defined the general constraint that prevents a member of staff
from managing more than 100 properties at the same time using the following assertion: