Differences

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

Link to this comparison view

Next revision		 Previous revision
tech-notes:sql:index [2019/08/19 17:09] – created gerardorourketech-notes:sql:index [2019/08/20 10:32] (current) – [SQL Indexing] gerardorourke
Line 5: Line 5:
 * 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====
 +{{:tech-notes:sql:indexseekexample-good.png?direct&400|}}
 +
 +==== Bad SQL Example using a Scan - taking over a minute and 45 seconds to run ====
 +
 +{{:tech-notes:sql:indexscanexample-bad.png?direct&400|}}
  
  • tech-notes/sql/index.1566230951.txt.gz
  • Last modified: 2019/08/19 17:09
  • by gerardorourke