Our Partnership Status

EMS SQL Manager for Oracle

On-line Documentation

Using SQL Manager for Oracle, you can viewthe planfor each of the queries created and executed in the application. The query plan is available within the correspondingPlantab.

To view thePlanof a query, openQuery Builderand use the Explain queryitem of the Navigation bar.

ThePlantab allows you to view the sequence of actions performed by the database server in the process of the query execution, and the amount of system resources used for the query execution.

If necessary, you can specify that thePlantab appears automatically upon query execution in Query Builder: select theExplain query on executionoption available within the Tools | Query Builder section of the Environment Options dialog.