News for hackers. Stuff that matters.

A comment on Can adding an index make a non SARGable query SARGable?. Parent comment

Re:Can adding an index make a non SARGable query SARGable? by hotsauceror on Friday October 18, 2019 @07:17PM (#21295821)
Actually the last time I checked, materialized views had a ton of restrictions on them, including things like not being able to use joins. Has that changed in recent versions?
[ Parent | on HN ]
Re:Can adding an index make a non SARGable query SARGable? by BrentOzar on Friday October 18, 2019 @07:54PM (#21295944)
You've been able to do joins in them for a decade. You just can't do self-joins. (But there are indeed a ton of restrictions.)
[ Parent | on HN ]
Re:Can adding an index make a non SARGable query SARGable? by hotsauceror on Friday October 18, 2019 @08:21PM (#21296040)
According to this here web site, it also forbids outer joins, which is probably what I was remembering.

https://docs.microsoft.com/en-us/sql/relational-databases/vi...

[ Parent | on HN ]
Re:Can adding an index make a non SARGable query SARGable? by Pxtl on Saturday October 19, 2019 @12:58AM (#21296832)
They're basically only usable on a super blue moon lunar eclipse.
[ Parent | on HN ]