SQL Generation Parameters: Widely Used

While creating Universe which of the SQL Parameters are widely used and in what scenario. As I guess most of the time default values are sufficient.

e.g Have you used AUTO_UPDATE_QUERY or any other parameter and in what scenario.

Thanks,

Kuldeep