It depends on the kind of investigation. It takes training to do undercover well, for example; but being in the field, asking questions and gathering information, that's not as intense. Though for both one needs to be able to think on one's feet.