Microsoft Corporation
DATA LAKE WORKLOAD OPTIMIZATION THROUGH INDEX MODELING AND RECOMMENDATION

Abstract:

Methods, systems and computer program products are described herein that enable data workload optimization through "what-if" modeling of indexes and index recommendation. In an example aspect, a system is configured to accept a workload in the form of a plurality of data queries, extract indexable columns from the queries, generate candidate indexes from the indexable columns, select and then build the best candidate indexes. Furthermore, the system may receive a query, generate a query plan for the query configured to use one or more of the built candidate indexes, and execute the query plan to generate a query result.