I do have a database which is about 150 GB. Today I use the useual update statisticis.
In this database there is big tables about 15 - 20 GB, which is fragmented.
The update statictics takes about 18 houres.
I would like to know if I run the right update statistics or should I chang it ? at last time I did test to run update statistics high for cople of tables and I did note a faster query result.