Compound Index vs Single Index with all compound fields

Working with Data
, ,
2

Hi Patrick,
It would be really helpful if you share the output of explain so that we can see what part of the query is taking that much long to execute or even if the index is being used or not.