Question regarding single index and compound indexes

[steevej (Steeve Juneau)]

@Sushant_K, a followup on this would be appreciated. If you made any progress, please share.