"Standard Scan. Only the possibly dangerous files are scanned, according to their content. The file extension is ignored. Again, only the viruses corresponding to the particular file type are searched for.
Thorough Scan. All files are tested, against all viruses. "
Source: Avast Help Files
I'll let others give opinions on what is the best type of scan.