This database property allows SQL Server to automatically create stats for a single non-indexed column if they are missing when
it is used in a where or join condition. This ensures the optimizer will have the necessary information to choose a plan. The
statistics automatically created by SQL Server will start with _WA_ in their name.
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment