When restoring a table with a filtered index using Object Level Recovery, the filtered index is restored but missing the WHERE clause, rendering the filtered index as a nonfiltered index.
e.g.
Original:
GO
Generated by OLR:
CREATE INDEX [IX_Filtered] ON [dbo].[OLR_Test]
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center