Indexes are great. They speed up our queries. In fact, without them relational database systems wouldn’t work. Different indexes work best for different queries. In a system with a lot of queries that means we could need a lot of indexes. Fortunately we can have up to 999 non-clustered indexes per table and one clustered…