Re: Update statistics of the informix.xxx tables.

>Is the update statistics scenario of the informix.systables alike tables >of a database the same as for the users tables. ? For the most part the access to these tables use a "fixed plan". Since this information is mainly needed by the optimizer to generate the query plan, we don't optimize the internal queries made to the systables. However, if you plan on making queries directly against the catalogue tables, you might want to run update statistics, just like you would against your user data tables. For the most part a simple "update statistics medium" would more than sufice. Madison Pruet