Structured explain plan

Analytics
New Member

Structured explain plan

Hi guys,

 

I wanted to know whether teradata can provide the explain query plan for a query in a structured format(JSON/XML) so that it can consumed by code with ease. For eg: postgres can return the plan as json with the hierarchy present in the query plan expressed via the hierarchy of the json itself.

 

Also, I wanted to know whether there are any opensource teradata query plan visualiser available that I can get some inspiration from.

 

Thanks in advance

Tags (2)
1 REPLY
Junior Contributor

Re: Structured explain plan

There's EXPLAIN IN XML SELECT ...

and the Visual Explain utility as part of TTU