There's more...

By understanding the keywords of the explain and how the optimizer works internally in terms of how SQL statements are executed on a Teradata system, you can assess the quality of each query. This information allows you to track down performance issues. Here are more keywords; if this doesn't match with your query nature and you suspect that this should not be in your explain, you might need to work on alternatives:

• JOINS: The following table explains the different types of joins and their uses: