SYSSTATISTICS

iclbloom · Post by **iclbloom** » Mon Jun 18, 2001 9:25 am

Is SYSSTATISTICS in all db's (I don't see it?)

SYSSTATISTICS keeps statistics about tables, such as the number of rows and amount of data in them. This information is intended for the SQL engine to use to help it make better choices when choosing indexes.

Thanks
Leon

Post by **John** » Mon Jun 18, 2001 10:53 am

Yes, that table should exist in all databases that are created by versions of Texis since the beginning of 2000, or when those versions of Texis try to store statistics in databases created with an older Texis.