Fundamental changes were made in Microsoft SQL Server 7.0 base-table organization that allow the query processor to make use of more secondary indexes, which greatly improves performance for decision support applications. The query optimizer has a wide set of execution strategies, and many of the optimization limitations of earlier versions of SQL Server have been removed. In particular, SQL Server 7.0 is less sensitive to index-selection issues, resulting in less need for tuning.