Advertisement

Key Concepts

Chapter
  • 282 Downloads

Abstract

The aim of this chapter is twofold. First, to avoid unnecessary confusion, I'll introduce some terms that are used repeatedly throughout this book. The most important include selectivity and cardinality, soft and hard parses, and bind variable peeking and extended cursor sharing. Second. I'll describe the life cycle of SQL statements. In other words, I'll describe the operations carried out in order to execute SQL statements. During this discussion, special attention will be given to parsing.

Keywords

Server Process Execution Environment Execution Plan Query Optimizer Bind Variable 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Christian Antognini 2008

Personalised recommendations