Popping the Hood on Query Execution

02/09/2021 by Kim Battaglia

Have you ever had a query that was not performing as you expected but you were not sure how to get more information on what was occurring under the hood during 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.