Popping the Hood on Query Execution

When running queries invoked by SAS, there are several tools available to assist in answering this question. Maybe you have used SASTRACE in the past but what can you use today with FEDSQL and DS2?

Have you ever used the EXPLAIN statement against a DBMS query to look at the optimizer’s plan?

This paper explores five tools that can be used to see what is occurring ‘under the hood’ during query execution: SASTRACE, IPTRACE, EXPLAIN, _METHOD and _TREE.