Reading Explain plan

SRA1

Hi Guys,

Is there any existing thread for "How to read explain plan for complex queries".

How to install the graph wiz for reading plan in windows. what r ur suggestions in reading complex queries.

 

SruthiA

Hi,

 

 

      Please go through the below link. This link contains sections which explains on how to understand the output of EXPLAIN PLAN

 

 

https://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/AdministratorsGuide/EXPLAIN/AboutEXPLAINOutput.htm%3FTocPath%3DAdministrator's%2520Guide%7CUnderstanding%2520Query%2520Plans%7CAbout%2520EXPLAIN%2520Output%7C_____0

 

 

Thank you

Sruthi