We continue to analyze the effects that initialization parameters, statistics and hints have on SQL statement access paths. In this blog, we’ll take a look at the hints we can use to influence the optimizer to select an access path that is different from the one it would normally choose. We’ll also review a few [...]

If you want to become an access path guru, you’ll need to spend some time learning how optimization parameters, statistics and hints affect SQL access paths and statement performance. This blog will provide you with a few hints and tips to help you begin your scientific analysis of the Oracle optimization process. In upcoming blogs, [...]

Introduction In today’s business environment, being a successful DBA is more than just being technical. If you want to excel in this profession, you must be seen as someone who understands both the business and technical aspects of the applications you support. In last week’s post, I started providing a general set of recommendations on [...]