The fastest way of performing a task is to avoid performing it at all - 2nd best is to reduce the number of times you perform the task. In this session I'll examine a small number of recent examples of production code where careful analysis of the requirements showed how to re-engineer to avoid redundant work, allowing significant performance improvements. The examples shown will vary in complexity from very simple to subtle and thought-provoking. The session will also include a couple of pointers to the benefit of investigating some of the newer, less commonly used, features of Oracle's SQL.