Hi,
I have run create stats for a table in my database.
For example:
CREATE STATISTICS stats1
ON myTable(FundID) WITH FULLSCAN
(I also have a maintenance plan that updates stats with full scan for every table in the database)
However, I get warnings in my execution plan that this column "FundId" is a "Columns With No Statistics"...
I've also dropped and recreated the index (which holds "FundId") several times - no dice.
Why is this? How can I get rid of the warning? I can't seem to find any info. Baffled.
Thanks
I have run create stats for a table in my database.
For example:
CREATE STATISTICS stats1
ON myTable(FundID) WITH FULLSCAN
(I also have a maintenance plan that updates stats with full scan for every table in the database)
However, I get warnings in my execution plan that this column "FundId" is a "Columns With No Statistics"...
I've also dropped and recreated the index (which holds "FundId") several times - no dice.
Why is this? How can I get rid of the warning? I can't seem to find any info. Baffled.
Thanks