Timeline for Filtered index statistics refresh threshold
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 13, 2017 at 12:43 | history | edited | CommunityBot |
replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/
|
|
| Oct 8, 2012 at 19:05 | vote | accept | billinkc | ||
| May 7, 2012 at 12:11 | answer | added | Brent Ozar | timeline score: 6 | |
| Feb 14, 2012 at 19:06 | comment | added | JNK |
have you checked the actual data in the table vs the stats? Try something like SELECT OfferID, COUNT(*) FROM MyTABLE Where Offerstatus = 0 GROUP BY OfferID and see how it lines up with the stats you have
|
|
| Jan 23, 2012 at 18:21 | comment | added | JNK | This is not a full answer, but I would recommend rebuilding that index whenever the table itself needs an update. I don't know of an automated way to do this but you can pretty easily check the stats and kick off a rebuild as needed. Since you can rebuild online and filtered indexes are smaller anyways, it probably won't hurt too much to just rebuild it on an interval. | |
| Jan 23, 2012 at 17:39 | history | asked | billinkc | CC BY-SA 3.0 |