By querying these dynamic management views using a query similar to the one shown below you can see all of the indexes which the SQL Server recommends creating. Do NOT simply create these indexes.

What is a view in SQL? A view is a virtual table created using a SQL SELECT query. It does not store data physically; instead, it pulls real-time data from one or more base tables. Views simplify ...

New for SQL Server 2016 is the ability to place a Columnstore Index on an In-Memory Table.