1- Refresh of the connection takes care of it. 2- Analyze be performed outside of arccatalog by using the 'sdetable -o update_dbms_stats' command. 3- A separate analyze command could be created and customized for ArcCatalog to run on selected objects.4- Analyze could be done using sql at the database level or from a command in arcobjects to execute sql.