Reading Explain plan

Forum|Forum|10 years ago
March 18, 2016
1 reply
6 views

Forum|alt.badge.img

+1

SRA1
Participating Frequently

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.

Forum|alt.badge.img

+1

SruthiA
Participating Frequently
Forum|Forum|10 years ago
March 20, 2016

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

Like