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

Services

Contact Us

Whitepaper

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.


Zencos Icon
© Zencos - 2023 - All rights reserved

When you visit or interact with our sites, services or tools, we or our authorised service providers may use cookies for storing information to help provide you with a better, faster and safer experience and for marketing purposes.