Improving the performance of queries for special situations

You can use special techniques to improve the access paths of queries for certain particular types of data and certain specific types of applications.