Search Options
close
Search the following clips:
All Clips
Everyone's Clips
My Guides
Sign Up
Install
Learn More
Login
Missing Column Statistics
Osolage
follow
0
4-10-2007 4:37 PM
284 views
tags:
sql server
,
database
,
performance tuning
Add a Comment
Login
to Comment. Not a member yet?
Sign up
Today's Top Clips
The Unusual Reproductive Power of the Anglerfish
Glenda Dobbs-Palinstein
One in Eight Americans Use Welfare for Food
Couric Rips Obama
Interesting faces
Visualising a Billion Dollars
Hero Dog Tries To Help Wounded Dog
Singapore to Bangkok " Jungle Railway"
The Scandal of Hunger in America
12 Coolest Nutcrackers
visit the
Top Clips page
View the Top Clips from
April 10, 2007
Embed This Clip In Your Site...
<div style="margin: 12px 0px; font-family: arial; color: #333333; background: #ffffff; border: solid 4px #e5e5e5; width: 100%; clear: left;"><div class="CM_CTB_Content_Wrap" style="margin: 0px; padding: 0px;background-color: #ffffff;"><div style="border-bottom: solid 1px #dcdcdc; white-space: nowrap; margin-bottom: 8px; background-color: #eeeeee ;background-image: url(http://clipmarks.com/images/source-bg.gif); background-repeat: repeat-x; height: 24px; line-height: 24px; vertical-align: middle; padding-bottom: 4px; color: #666666; font-size: 10px;" ><a href="http://clipmarks.com/clip-to-blog/" title="see clips that are hot right now"><img src="http://content.clipmarks.com/blog_embed/a97c23c5-3680-4958-9832-651984d9b721/9BB391C8-33CC-4C53-8374-8F744E6DAEFD/" alt="" width="19" height="19" border="0" style="vertical-align: middle; margin: 0px 4px; display: inline; border: none; float:none;" /></a>clipped from <a title="http://www.sql-server-performance.com/sql_server_profiler_tips.asp" href="http://www.sql-server-performance.com/sql_server_profiler_tips.asp" style="font-size: 11px;">www.sql-server-performance.com</a></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.sql-server-performance.com/sql_server_profiler_tips.asp"><STRONG>Missing Column Statistics</STRONG>: Tells you which columns in your query are missing statistics, such as the Index Statistics used by the Query Optimizer to help it evaluate the most efficient query plan. If one or more columns of statistics are missing, the Query Optimizer may not select the best query plan, hurting performance. To help prevent this problem, consider the following: Be sure you have "auto create statistics" turned on for your database, use the CREATE STATISTICS statement to manually create the statistics on the missing columns, or use the Index Tuning Wizard to identify and automatically create the needed statistics.</blockquote></div><div style="margin: 0px 6px 6px 4px;"><table style="font-size: 11px;border-spacing: 0px;padding: 0px;" cellpadding="0" cellspacing="0" width="100%"><tr><td style="background:transparent;border-width:0px;padding:0px;"> </td><td align="right" style="background:transparent;border-width:0px;padding:0px;width:107px" width="107"><a href="http://clipmarks.com/share/9BB391C8-33CC-4C53-8374-8F744E6DAEFD/blog/" title="blog or email this clip"><img src="http://content6.clipmarks.com/images/c2b-foot.png" border="0" alt="blog it" width="107" height="17" style="border-width:0px;padding:0px;margin:0px;" /></a></td></tr></table></div></div>
New from the makers of Clipmarks:
Amplify.com - Don't just share the news...Amplify it!
Clipmarks
Home
New Clips
Top Clips
Dashboard
Popular Topics
News
Life
Science
Technology
Entertainment
Get Started
Sign Up
Install Clipping Tool
How Clipping Works
Clip-to-Blog™
ClipSearch
Tools and Resources
FAQ
ClipWeek
Top Clippers
Top Tags
Site Map
About Clipmarks
About Us
Contact
Copyright
Privacy
EULA
OK