You will have to determine whether the gains in query performance outweigh the affect to performance during data modification and in additional disk space requirements.