Reputation
Top tag
Next privilege 75 Rep.
Set bounties
Badges
6
Newest
 Teacher
Impact
~986 people reached

  • 0 posts edited
  • 0 helpful flags
  • 6 votes cast
Aug
27
comment Performance tuning for gap analysis of table
Thanks for the idea, Rob. I think I tried using CTE before, but figured I would need to index the temp results to get the perf I wanted. Maybe I can try to fiddle with this and the indexes on the source table. Here is the statio for just with CTE alone:
Aug
27
awarded  Student
Aug
27
asked Performance tuning for gap analysis of table