Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
tech-notes:sql:index [2019/08/20 09:15] – gerardorourketech-notes:sql:index [2019/08/20 10:32] (current) – [SQL Indexing] gerardorourke
Line 4: Line 4:
  
 * https://www.red-gate.com/simple-talk/sql/performance/identifying-and-solving-index-scan-problems/ * https://www.red-gate.com/simple-talk/sql/performance/identifying-and-solving-index-scan-problems/
 +
 +  *You can select the **'Display Estimated Execution Plan'** (4 to the right of the '! Execute' button).
 +  *You can select **'Include Actual Execution Plan'** (7 to the left of the '! Execute' button), so see exactly how the SQL was run, after you execute it.
 +
 +The below examples are taken from the "Actual Execution Plan"
  
 ==== Good Example with a Seek taking under a second to run==== ==== Good Example with a Seek taking under a second to run====
  • tech-notes/sql/index.1566288947.txt.gz
  • Last modified: 2019/08/20 09:15
  • by gerardorourke