(Paul White) I have previously written about the benefits of using NOEXPAND hints, even in Enterprise Edition. The details are all in the linked article, but to summarize briefly:
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help