Java Script needs to be enabled for Video to Load.

# Query Optimization - Heuristics Based Optimizations

If you dont see the Video even after 10 seconds,

##### In this 44 mins Lesson you will Learn about following concepts.

Heuristics based Optimization, Algorithm, Example , 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.