Ways for Oracle and SQL Server to regain statistical information

1. Oracle's command to regain statistical information

exec dbms_stats.gather_schema_stats (ownname ='LCoe739999'gather  "for allcolumns size repeat'4)

# need to modify ownername options designation and degree generally related to CPU data

You can rebuild the index before retrieving the statistics again

Select '  "'  rebuild; '  from user_indexescopy come out and execute.

2. SQL Server to rebuild the index of the statement is relatively simple, before the copy

' DBCC dbreindex ("?") '

How SQL Server Library re-obtains statistics

Log on to the SA user and modify the permissions of the LC user

The way to add the sysadmin GUI is

To switch to LCMI709999 's account execution command after adding the role of the sysadmin

EXEC sp_updatestats;

Note Be sure to remove the role after execution, otherwise there may be a problem.

How Oracle and SQL Server re-obtains statistical information