Java Script needs to be enabled for Video to Load.

Query Optimization - Equivalence of Expressions and Cost Based Optimizations

Loading Video Lesson

If you dont see the Video even after 10 seconds,
then please download and Install the Flash Player


In this 46 mins Lesson you will Learn about following concepts.
Query Optimization - Equivalence of Expressions and Cost Based Optimizations

Introduction, Equivalence of Expressions, Equivalence Rules, Minimal set , Cost based optimizations, and related Topics.


Related Video Lessons in this Series

Query Processing - Basic Concepts, Query Cost and Selection Algorithms

56 mins Video Lesson

Introduction, Query Processing Process, Measures of Query Cost, Disk Access Costs, Selection: Algorithms, Complex Selections: Algorithms, and other topics.

Query Processing - Sorting Algorithms and Nested Loop Join

45 mins Video Lesson

Sorting: Algorithms, External Sort/ N-way Merge, Join Algorithms, Nested Loop Join, and other topics.

Query Processing - More Join Algorithms

47 mins Video Lesson

Block Nested Loop Join, Index Nested Loop Join, Merge Join, Hash Join, and other topics.

Query Processing - Complex Joins, Duplicate Elimination and other operations Algorithms

47 mins Video Lesson

Hash Join Algorithm Explanation, Hash Join: Restriction on 'n', Recursive Partitioning, Complex Joins: Algorithms, Duplicate Elimination: Algorithms, Projections: Algorithm, Aggregation: Algorithms, Set Operations: Algorithms, Outer Join: Algorithms, Modified Merge Join, Hash Join, and other topics.

Query Processing - Evaluation of Expression

25 mins Video Lesson

Evaluation Of an Expression, Materialization, Pipelining, and other topics.

Query Optimization - Equivalence of Expressions and Cost Based Optimizations

46 mins Video Lesson

Introduction, Equivalence of Expressions, Equivalence Rules, Minimal set , Cost based optimizations, and other topics.

Query Optimization - Heuristics Based Optimizations

44 mins Video Lesson

Heuristics based Optimization, Algorithm, Example , and other topics.

Distributed Database - Basic Concepts, Fragmentation and Allocation

54 mins Video Lesson

Distributed Computing System, Distributed DB, Distributed Database, Advantages of DDBMS, Special Functions of DDBMS, Fragmentation, Horizontal, Vertical, Mixed/ Hybrid Fragmentation, Fragmentation Schema, Allocation, Allocation Schema, and other topics.

Member's Zone