What is the use of update statistics?

 

Txlicenhe Ma

 

I haven't paid much attention to it. I have just learned a trick and I haven't figured it out yet.

In this case, there is a view that uses several tables, one of which changes some information and always times out and expires during foreground operations (the frontend sets the time-out period not to be 60 s)

 

Today I used the update statistics table name.

Then you can proceed to the foreground.

 

I did not expect this statement to solve the timeout problem.

 

Lt1129 Tao Ge

Updating all statistics of a table is not very useful !!!

 

W75251455 chopped

Pass by and learn !! By the way, Jack Ma

 

Zjcxc producer Creation

If the statistics are not updated (which generally means inaccurate), the query optimizer cannot select the correct execution plan, because the query optimizer evaluates whether indexes should be used, the index that should be used depends on the statistical information for judgment.

 

Zjcxc producer Creation

It is estimated that the query optimizer did not select the correct execution plan because of the distortion of statistics.

This problem rarely occurs when the automatic update statistics option of the database is enabled.

 

Mengmou

Statistics should be updated automatically.