Zencos has merged with Executive Information Systems (EIS)
Free Strategy Consultation
Zencos Icon


Contact Us


Popping the Hood on Query Execution

Data Management


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.

Related Insights


How Successfully Migrate Your SAS Environment to the Cloud


Using SAS Data Integration Studio to Load Covid-19 Case Surveillance Data


Bridge Your Analytical Code Gaps: How to Build Custom Applications with SAS Viya


9 Key Action Steps Towards a Successful SAS 9 to SAS Viya Migration