Eirikur Eiriksson (8/25/2014)
tony28 (8/25/2014)
so what do you think, is any soulution than update statistics ? because with these high values I cannot use this procedure, this is very heavy for server if somebody will stil exec..And I can update stats just in saturday because we work 24/5
Outdated statistics will never help, do you have "Automatically Update Statistics" enabled?
Quick question, can you post the DDL for the tables and some sample data, makes it a lot easier to help;-)
My first thought is to look into the query, looks like some room for improvement exists there.
😎
yes I have enabled, but what I know there is some % after will be automatical updated and this is not possible...
And I checked on updated data and it is ok, on notupdated there is problem..
I can post DDL, and next , but this problem is just with lot of data, if I select for example few rows it is ok...
I tried select just one row with from smaller tables and IO logical was 2, so maybe if there is 50000rows , io will be *2 ....
EDIT this table has little more rows, because this 50000rows is from one day and there is about 3months.