1. A method comprising: identifying a set of high load database query language statements; for each statement in the set, performing an optimization process on the statement; during the optimization process, generating a set of candidate indexes which could be used to improve an execution plan for the statement; selecting a subset from the set of candidate indexes using a model to remove expensive indexes; identifying an index in the subset that can satisfy a different statement; consolidating the identified index in the subset with an index for the different statement; and determining an execution plan for the statement using the subset of indexes.