Toad World® Forums

SQL Server Filtered Index


#1

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


#2

Hello Bohdar,

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

Regards,

Lukas


#3

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

TDM_filtered_index.png


#4

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.

Regards,

Lukas