Timeline for Get count of near points based on 2 unrelated tables
Current License: CC BY-SA 4.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 6, 2020 at 16:14 | comment | added | Zoinky | I have provided the execution plan, it actually takes 14:35, the alternative query you provided takes 35min and counting (going now) | |
| Sep 6, 2020 at 15:24 | comment | added | David Browne - Microsoft | Or try the alternative in the updated answer. | |
| Sep 6, 2020 at 15:23 | history | edited | David Browne - Microsoft | CC BY-SA 4.0 |
added 256 characters in body
|
| Sep 6, 2020 at 15:08 | comment | added | David Browne - Microsoft | Add the execution plan to your question. brentozar.com/pastetheplan | |
| Sep 6, 2020 at 14:51 | comment | added | Zoinky | This seem to be working but its very slow(10 min and still going) . I have about 250k records in cities and about 200k listings. Anything else I can do to speed this query up? | |
| Sep 6, 2020 at 14:41 | history | answered | David Browne - Microsoft | CC BY-SA 4.0 |