Well-designed, robust queries have the advantages of running faster and with fewer errors, as well as being easier to debug and maintain. This chapter describes some of the goals of query design, with particular attention to handling errors and tuning for performance.
Some of the elements of good query design include:
Queries that clearly convey their meaning are much easier to understand and therefore to maintain.
Expressions should be reusable in many parts of a query and across multiple queries.
Queries should be able to handle all possible combinations of values of input data.
Queries should handle dynamic errors gracefully, with useful messages.
Queries should be tuned for performance.
The rest of this chapter takes a closer look at these design goals.
3.145.174.253