Optimize queries that filter on multiple fields using Compound Indexes. Learn about index prefixing and the ESM (Equal, Sort, Range) rule.