What is the best codec?

There is no best, only different. Cineform, ProRes, DnxHD will give you the best image quality but the biggest files. MPEG-4 and H.264 are not as good, but the files are much smaller and more manageable.