SQL Query Design Patterns and Best Practices by Steve Hughes & Dennis Neer & Dr. Ram Babu Singh & Shabbir H. Mala & Leslie Andrews & Chi Zhang

Author:Steve Hughes & Dennis Neer & Dr. Ram Babu Singh & Shabbir H. Mala & Leslie Andrews & Chi Zhang
Language: eng
Format: epub
Publisher: Packt
Published: 2023-03-15T00:00:00+00:00

This command will then generate the actual query plan in XML format. It contains the information during the execution of the query and executes the query.

Execute the referenced query here to get the estimated query plan:

SET SHOWPLAN_XML ON; GO SELECT TOP (1000) [CityID] ,[CityName] ,[StateProvinceID] ,[Location] ,[LatestRecordedPopulation] ,[LastEditedBy] FROM [WideWorldImporters].[Application].[Cities] ; GO SET SHOWPLAN_XML OFF; GO

Here is how the query is executed:

Figure 9.9 – The XML plan of the query in the query result pane

In the Results pane, right-click the result and select the Save Results As… option, as referenced here:

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.