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 shawnz on Friday October 18, 2019 @10:57PM (#21296504)
Isn't an mssql indexed view essentially a materialized view? Postgres also supports indexes on materialized views.
[ Parent | on HN ]
Re:Can adding an index make a non SARGable query SARGable? by dragonwriter on Saturday October 19, 2019 @03:27AM (#21297314)
An MSSQL indexed view is like a materialized view, except it's not actually materialized beyond the index, as I understand it, and there are restrictions on the view definition that mat views don't have, and it updates automatically.
[ Parent | on HN ]