Can I read Heuristic Query Optimization in DBMS on EtoBox?

Heuristic Query Optimization in DBMS by Krishna Kumar is a document available to read on EtoBox.

What is Heuristic Query Optimization in DBMS about?

The document discusses heuristic query optimization techniques. It begins by covering query processing in a DBMS, including translating SQL queries to relational algebra. It then discusses using heuristics to reorder query operations for more efficient evaluation. Specific heuristics covered include commuting and cascading select and project operations, and applying operations that reduce intermediate result sizes first. Transformation rules for relational algebra operations like selection, projection, join

Author

Krishna Kumar

Language

EN