Timeline for Sql select slow on filter for key, but not for primary key, how can I hint the priority
Current License: CC BY-SA 4.0
20 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 27, 2022 at 11:00 | 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. | |
| Dec 23, 2021 at 15:04 | 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 21, 2021 at 4: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. | |
| Apr 21, 2021 at 16:08 | 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. | |
| Dec 12, 2020 at 23:01 | 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 10, 2020 at 19:17 | review | Close votes | |||
| Aug 18, 2020 at 3:04 | |||||
| Aug 10, 2020 at 18:01 | 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. | |
| Apr 1, 2020 at 13:04 | 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. | |
| Dec 1, 2019 at 4:04 | 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. | |
| Jul 27, 2019 at 5:00 | 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. | |
| Feb 5, 2019 at 13:30 | comment | added | Martin Smith |
Any update on providing the XML for the actual plan? That will allow us to see if things like estimated row count for t.StartDate > DATEADD(hour,-1,GETDATE()) is correct
|
|
| Feb 5, 2019 at 4:36 | comment | added | KumarHarsh | "Hint the priority" require lot of experience and practice,better concentrate on writing better query . | |
| Feb 3, 2019 at 21:45 | answer | added | HandyD | timeline score: 1 | |
| Feb 2, 2019 at 19:17 | comment | added | Martin Smith | You should provide actual execution plan - not estimated | |
| Feb 2, 2019 at 18:42 | comment | added | Visky Máté | Thx, I did it, and thx for the hint for the webpage! | |
| Feb 2, 2019 at 18:41 | history | edited | Visky Máté | CC BY-SA 4.0 |
update with ep
|
| Feb 2, 2019 at 13:36 | comment | added | Dan Guzman | Upload your actual plans and add the links to your question. | |
| Feb 2, 2019 at 10:33 | comment | added | ypercubeᵀᴹ | If you can provide the actual execution plan of the slow query, even better. | |
| Feb 2, 2019 at 10:32 | comment | added | ypercubeᵀᴹ | Edit the question please and add the CREATE TABLE statements including all indexes, for both tables. | |
| Feb 2, 2019 at 4:57 | history | asked | Visky Máté | CC BY-SA 4.0 |