July 23, 2009 at 3:39 pm
How can we need to remove Table Stats Warning on Table Varibale ..
July 23, 2009 at 3:48 pm
Where and how are you gettig this error?
July 23, 2009 at 4:43 pm
I am confused since table variables doesn't have statistics.
N 56°04'39.16"
E 12°55'05.25"
July 23, 2009 at 8:52 pm
Ditto.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 24, 2009 at 2:06 am
John Paul (7/23/2009)
How can we need to remove Table Stats Warning on Table Varibale ..
Even though SQL Server does not support column statistics on table variables, that doesn't stop it from warning you about the lack of statistics in a graphical query plan. That said, I haven't seen a missing statistics warning on a table variable since SQL 2K days.
Some people regard this as a bug (which may or may not be 'fixed' now), others find it useful since it indicates that a temporary table (which does support statistics) might be a better choice...if the statistics would be useful in producing a better plan.
In any case, the only way to avoid the warning would be not to use a table variable. There isn't enough information in your original post to say whether one is to be preferred over the other.
Paul
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy