How does index filter come into existence?


Lab 3.1 suggests that we have a look at the docs to understand more about hint() method. The docs here specify that the hint will be ignored if there’s an index filter. And the section on index filters only talks about what happens when an index filter is present. But how does an index filter come into existence in the first place? Does a user create it? Or does the query planner create them when certain conditions are met?

Best Regards,

@ andrewnessinjim

There is additional documentation here that describes how this works. Good luck.

1 Like