for modern drives it is best to use AHCI mode, you will notice a pefromance improvement even on magnetic HDD's
if you already have windows installed make sure to lookup the ahci registry fix, apply it before restarting and enabling ahci or you will bsod on boot.