I have table Reg_Stats without any index, statics is not updating automatically but i have enabled the autoupdate statics also (is_auto_create_stats_on,is_auto_update_stats_on both are one) And my second promblem once i updated statics manualy it showing correctly but in execution plan it is not showing properly.