Where can I find query plan in Sybase?
Where can I find query plan in Sybase? You can use showplan in conjunction with other set commands. To display query plans for a stored procedure, but not execute them, use the set fmtonly command. How do you get the query plan without executing the query? SHOWPLAN_XML – Displays an XML based estimated execution plan […]