Choosing the correct index can be one of the single most effective mechanisms for enhancing performance within SQL Server. Because of this simple fact, it’s vital that you understand how indexes work in order to help you select the correct one for the job. Back in SQL Server 2016, the clustered columnstore index was introduced. Today, we actually get to pick our best storage mechanism for the data, whether a clustered rowstore or a clustered columnstore index, for the most common data access. Then we can add additional indexes to each to assist other query paths to the data.