63 reputation
6
bio website wds-it.com
location Olathe, KS
age 36
visits member for 2 years, 2 months
seen Jul 9 at 17:17

Coder for 17+ years.


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