There are three types of alogrithm used by SQL compiler for joining purpose:1) Nested join algo2) Hash join algo3) Merge join algoComplier choose any one of these algo based on the best suited for per...
In hash join hash table gets build using the inputs. Nested loops as the name implies uses looping construct strategy for storing and retrieving. In terms of performance comparison while retrieving da...
Rule Based Optimization is an older technique which is used for optimization of queries but follows a fixed rule or strategy for achieving the same. But in contrast cost Based Optimization is a later ...