Timeline for To INCLUDE or Not INCLUDE in an Index
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 31, 2022 at 20:57 | comment | added | DBASurvivor | sorry @MartinSmith, you are right: my answer was superficial. I just meant that in my test environment with my test data, a filtered index had given me better results. I promise that as soon as I get back to the office I will edit the answer by adding all the available details. tnks for your comment. | |
| Dec 30, 2022 at 11:36 | comment | added | Martin Smith | In fact that isn't even a valid filtered index definition "Incorrect WHERE clause for filtered index 'CoverTest1' on table 'object1'." | |
| Dec 30, 2022 at 11:32 | comment | added | Martin Smith |
Can you add some specific details of your tests rather than just asserting that you did some tests and this was the best? What was the setup? What were the results? Did you make any changes to the query? I'd be surprised if it matched (deleted = 0 or deleted IS NULL) to that filtered index
|
|
| Dec 30, 2022 at 11:27 | history | answered | DBASurvivor | CC BY-SA 4.0 |