Understand SQL Tuning Theories
Jon Heller · Apress eBooks · 2019
Algorithm analysis was a useful guide for understanding the foundations of Oracle performance. Now we must turn to the more traditional techniques and theories of database performance. First we need to discuss performance issues from the end user’s perspective. Then we will discuss several popular approaches to performance tuning. But all roads eventually lead to SQL tuning. For effective SQL tuning we need to understand the importance of execution plans, the operations available in execution plans, cardinality, optimizer statistics, transformations, and dynamic optimization features.