Toad World® Forums

Hot Key for EXPLAIN


#1

Would it be possible to add a hot key/quick key for EXPLAIN? In Teradata Studio one can highlight a query and press F6 to have it run the explain plan. Since I can’t use the built in explain plan in the ODBC connection, this would allow me to not type “EXPLAIN” all the time and have to remember to delete it.

Example

SELECT *
FROM TABLE;

In TD Studio, pressing F6 is the equivalent of

EXPLAIN SELECT *
FROM TABLE;