Research In Motion
The introductory section gives brief information on the strategies, an optimizer should follow. In order to examine the role of query optimization process in RDBMS, this paper will look at both static and dynamic process of optimization as well as all the general aspects of query optimization. The paper will then explore major principles of query optimization process with volcano query optimization. An enhancement to volcano query optimizer is proposed by adding some set of transformation rules and operators.