Home | Previous Page | Next Page   Migration to a Later Version of a Database Server > Converting to Dynamic Server 10.0 >

Update Statistics

After a successful conversion, you need to run UPDATE STATISTICS on some of the system catalog tables in your databases, as the following lists show.

For a conversion to Dynamic Server 10.0 from a Version 7.3x or Version 7.24 database server, run UPDATE STATISTICS on the following system catalog tables in Dynamic Server 10.0:

sysblobs
syscolauth
syscolumns
sysconstraints
sysdefaults
sysdistrib
sysfragauth

sysfragments
sysindices
sysobjstate
sysopclstr
sysprocauth
sysprocedures
sysroleauth

syssynonyms
syssyntable
systabauth
systables
systriggers
sysusers
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]