CHAPTER 20

image

Managing Statistics with TSTATS

This chapter explains a radical approach one can take to the management of object statistics on production systems. This approach has been named TSTATS, for “Tony’s Statistics,” by one of my clients, and I must say that I like the name. It appeals to my sense of vanity! However, as I have already stated, I am not the only one to have considered the issues addressed in this chapter, and others have developed similar solutions on their own, Adrian Billington being one such person.

I explained the problem that TSTATS addresses in Chapter 6: gathering statistics is a risky activity on production systems ...

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.