0 - 1 of 1 tags for single table join index

Hi,

Really wonder how these indexes are different, which one to use and where to use. Any help would be greatly appreciated.

Thanks.