Join Index usage

Database
Enthusiast

Join Index usage

Do we practically ever use join indexes? Can you please provide a real life scenario when join index would be beneficial in a production environment?