Posts

Showing posts with the label showplan

SQL Show Execution Plan of SQL Statement SHOWPLAN ALL

SQL Show Execution Plan of SQL Statement SHOWPLAN ALL --show the execution plan of any statement --set Showplan_all OFF OR ShowPlan_text ON--Then Run your query check and set the Showplan to OFF --Syntax SET SHOWPLAN_ALL { ON OFF } --Example SET SHOWPLAN_ALL ON--Table is not created ,only download  file  now