Community

Simple example on how to caputure the query execution plan from SQLFire

(Pas Apicella) The example below shows how we can capure the query plan for SQL running in SQLFire. Although any user can run an explain plan you must connect as a peer to show the query execution plan as the data is stored in the SYS.STATEMENTPLANS table.

Read More - Register for Free Membership

Tags: