Toad World® Forums

SQL Server Filtered Index


Hello, can you let me know how to create a filtered index in the model?


Hello Bohdar,

In the General tab of Index Properties simply enter the WHERE expression.




Interesting, the text “Expression…” is missing for me.



We have just found that the “Expression…” label disappears when you use 125% DPI in Windows, but filtered indexes should be still fully functional. A CR has been created for this issue: TDM-1366. We will try to fix this bug as soon as possible.

Thank you for reporting this. We are sorry for the inconvenience.