The Teradata EXPLAIN command can be added to the front of the SQL
statement and while execution it gives a detailed analysis for particular statement. The EXPLAIN command can be used to estimate what are the indexes to be used,how much time
a query will take and how many rows a query will be return. This command can be used as a useful debug tool to resolve problems with long processing times.
No comments:
Post a Comment