Opinionated Software

… we have opinions about everything!

Archive for the ‘Configuration’ Category

Trace Flag 4136 and PeopleSoft —

Trace flag 4136 effectively adds an OPTION(OPTIMIZE FOR UNKNOWN) to all SQL statements. This has the effect of making the optimizer ignore histogram statistics in generating execution plans. If you have extremely skewed data distributions this can actually result in a much better execution plan – it essentially gives the impression of more “consistent” performance […]