What are the typical parameters should be set for a data warehouse database?

Should optimizer_mode be set to choose or all_rows or anything else?

Thanks!