How would the ESR rule of Indexes behave if one of the fields is optional?

[V_N_A]

Hey Satyam, thank you for taking your time and replying. It was insanely helpful! Let me read all the resources you linked and get back to you!