You can't compress a file as avi. Avi is just a format for packaging information about the coded used, and the file itself, together - not a codec of it's own.
I have no idea what the best one is. I'd say DVD's, which are compressed using MPEG (some number) are the best in my uninformed opinion.