Reading TD Execution plan - Identify Good vs Bad query

Database
The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.
Enthusiast

Reading TD Execution plan - Identify Good vs Bad query

Hi,

I am looking for some guidance on how to distinguish between a bad TD execution plan & good TD execution plan ( apart from seeing 1=1 Cross join). Also, can you guys pls suggest what are the query parameters will help us to identify a bad query ?

 

Appreciate your response.

 

Thanks,

Sundar