How to chose an income protection covers? Is it really worth it?

A friend yesterday and also my former financial advisor suggested to have income protection insurance.

How does it work?

What approach to select one?

If covers only redundancy/restructuring or also performance?

What is your experience with that?