Can I add ‘with (NoExpand)’ after the select and before the where?
e.g. "select * from ThisView with (NoExpand) where … ".
My DBA has an idea to use an indexed view but it only makes a
difference if 'with (NoiExpand) is included.
Any thoughts from the more experienced programmers out there?