Timeline for Performance issue with larger resultsets SQL Server
Current License: CC BY-SA 3.0
18 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 7, 2020 at 22:23 | history | edited | CommunityBot |
added [query-performance] to 2412 questions - Shog9 (Id=1924)
|
|
| Mar 2, 2019 at 15:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Aug 3, 2016 at 17:20 | answer | added | user3777284 | timeline score: 1 | |
| Jul 28, 2016 at 7:37 | history | edited | user2939331 | CC BY-SA 3.0 |
added 195 characters in body
|
| Jul 28, 2016 at 7:28 | history | edited | user2939331 | CC BY-SA 3.0 |
added execution plans
|
| Jul 28, 2016 at 7:19 | comment | added | user2939331 | The execution plan of the one with many results: gist.githubusercontent.com/anonymous/… and with few results: gist.githubusercontent.com/anonymous/… I don't think the plans differ too much | |
| Jul 27, 2016 at 20:10 | comment | added | John Eisbrener | Post both the efficient and inefficient execution plans | |
| Jul 27, 2016 at 14:13 | history | edited | marc_s | CC BY-SA 3.0 |
added 10 characters in body
|
| Jul 27, 2016 at 11:55 | history | edited | user2939331 | CC BY-SA 3.0 |
Added more things I tried
|
| Jul 27, 2016 at 10:23 | comment | added | user2939331 | I tried changing the ISNULL to that yesterday, but that didn't change anything noticable. But i will consider using that for better readability. I have multiple indexes set at the table where i count from, the only ones relevant would be a nonclustered on RealtorId and a clustered primary key on ID. | |
| Jul 27, 2016 at 10:02 | comment | added | Aasim Abdullah | Do you have proper indexes applied and further change ISNULL options to somewhat "WHERE (@isForSale IS NULL OR reps.IsForSale= @isForSale)" | |
| Jul 27, 2016 at 9:54 | comment | added | user2939331 | I did look at the execution plan, but I am not very familiar with execution plans. There are 71769 records in the Database. I can upload the Execution plan XML if you want? | |
| S Jul 27, 2016 at 9:17 | history | suggested | Bogdan Bogdanov | CC BY-SA 3.0 |
Add some formatting
|
| Jul 27, 2016 at 8:56 | comment | added | Sir Swears-a-lot | Have you looked at the execution plan? | |
| Jul 27, 2016 at 8:55 | comment | added | Sir Swears-a-lot | How many rows are in the table? | |
| Jul 27, 2016 at 8:28 | review | Suggested edits | |||
| S Jul 27, 2016 at 9:17 | |||||
| Jul 27, 2016 at 8:05 | review | First posts | |||
| Jul 27, 2016 at 8:48 | |||||
| Jul 27, 2016 at 8:04 | history | asked | user2939331 | CC BY-SA 3.0 |