Why is it important to analyze , and what is analyze anyway ? well analyze is a method to gather statistics on table objects in order for the optimizer to choose the best way for executing queries . for example…