Timeline for Understanding about SQL index on DateTime Column
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 27, 2020 at 22:36 | comment | added | Randi Vertongen | @Sam That is great to hear! Don't beat yourself up too much about the downvotes, we have all been there starting out! It was a good question in itself but as much details as possible are always best :). Hope to see more from you on this forum. | |
| Nov 27, 2020 at 22:26 | comment | added | Sam | @RandiVertongen yes yes, that blogpost is actually exactly what I need. I tried to read the documentation from Microsoft as listed in the answer/comment, but it is too technical for me. You guys (David and Mike) are awesome because you guys are very technical. My question deserved downvotes. My apology and thanks y'all for your help... | |
| Nov 27, 2020 at 16:20 | comment | added | David Browne - Microsoft | Explained also in the docs: learn.microsoft.com/en-us/sql/relational-databases/… | |
| Nov 27, 2020 at 16:18 | answer | added | Mike Sherrill 'Cat Recall' | timeline score: 4 | |
| Nov 27, 2020 at 14:48 | review | Close votes | |||
| Nov 29, 2020 at 4:37 | |||||
| Nov 27, 2020 at 14:29 | comment | added | Randi Vertongen |
Hi, The compositie indexes, did you create an index on [CurrencyId,Orderdate] and [Orderdate,CurrencyId] as the key columns? Could you add the statements used? Otherwise it might come down to how much CurrencyId filters, your statistics, the query, .... Have you looked at this blogpost which explains it further?
|
|
| Nov 27, 2020 at 13:56 | review | First posts | |||
| Nov 27, 2020 at 14:31 | |||||
| Nov 27, 2020 at 13:55 | history | asked | Sam | CC BY-SA 4.0 |