A Branch-and-cut Algorithm for the Index Selection Problem

The Index Selection Problem (ISP) is a phase of fundamental importance in the physical design of databases, calling for a set of indexes to be built in a database so as to minimize the overall execution time for a given database workload. The problem is a generalization of the well-known Uncapacitated Facility Location Problem (UFLP). We formulate ISP as a… CONTINUE READING