Introduction
What is this book about?
How many of us have been woken at some antisocial hour because a SQL statement that was performing well suddenly started behaving badly because of a changed execution plan? In most circumstances, Oracle would probably recommend that customers suffering repeatedly from such issues investigate the use of SQL Plan Baselines, Oracle’s strategic feature for stabilizing execution plans in a production environment. This book introduces TSTATS, the name given by one of my clients to a controversial technology that bypasses altogether the need to gather object statistics on a production system and can be thought of as an alternative to SQL Plan Baselines.
Although Chapter 6 and Chapter 20 are dedicated to the issue ...
Get Expert Oracle SQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
