this is for holding javascript data
H.S.Bhathiya(110059X) edited section_Query_Optimization_and_Execution__.tex
about 8 years ago
Commit id: de581f6f462e614ebc2ffac25b5dc2db80524bbd
deletions | additions
diff --git a/section_Query_Optimization_and_Execution__.tex b/section_Query_Optimization_and_Execution__.tex
index 0548c44..ef1769a 100644
--- a/section_Query_Optimization_and_Execution__.tex
+++ b/section_Query_Optimization_and_Execution__.tex
...
\subsection{Challenegs in Bushy Tree Implementation}
Moving from left-deep tree to a Bushy tree is a challenge as the number of possible structures in bushy trees are much larger. Left-deep trees have only one structure regardless of the number of tables involved. Therefor the number of possible permutations are N! . But for bushy trees possible number of structures are given by \\
$$ S(N) = 1 if N
\ =
1\\ \ 1
\\
S(N) = $\displaystyle \sum_{N=1}^{i} (N)(N-i)$
\ if
\ N > 1 $$\\
Therefore the number of possible permutations are $S(N)*N!$. Unlike left-deep tree case, estimating the cost for all the possible bushy trees is computationally infeasible for moderately large N (~7). Therefore it is required to come with a heuristic to select set of permutations for cost computations.
\subsection{Heuristics to Select Bushy Trees}