Guidelines For Better Queries Performance In Database Systems

Abstract

Query optimization is more than transformation and query equivalence. Database designers must develop a robust cost metric, and consider cost and search space. Building extensible enumeration architecture is important, understanding the existing framework makes effective query optimizations.This paper presents effective guidelines to Database designers to guide them for a better understanding to effective query optimization factors . It identifies and presents , effective guidelines for Query evaluation to the mostly used databases (Relational, Deductive, Object Oriented, Multiple , Distributed & Parallel ) types approaches that affect optimizing relational query minimizes the most relevant performance measures (like CPU, Memory, resource usage,… etc).