Identifying preferred indexes for databases

摘要

Preferred indexes for a relational database are identified. Queries from users are received and a sample of user queries are analysed to identify candidate indexes. Index permutations are identified by processing the candidate indexes in combinations identified from the sample of user queries. A preferred index set is identified by comparing the performance of the index permutations.