Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Execution plan weirdness - help

Status
Not open for further replies.

takaoki

Programmer
Aug 28, 2008
39
ZA
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top