Drive Cable Select??

While I understand the general use of the cable select position on a drive; Can anyone either point to an in-depth explaination of the use and when to apply it vs. not or give a full explaination yourself. All the points to the most in-depth answer.