What is the difference between Single Field Indexes & Compound Indexes?
Single Field Indexes: Indexes that are created on a single field.
Compound Indexes: Indexes that are created on multiple fields. These indexes can improve performance for queries that use multiple fields in the query condition.