Hi Mark, > >So, how do I get at the information that I would've pulled from >TABLESTATISTICS? >
If you have created your database with release 7.6 you can get information about table sizes and row counts via the system table FILES, e.g. Select * from FILES F, TABLES T where F.FILEID = T.TABLEID This should be quite fast as the counter values are stored in the database and you don't have to traverse the B* tree of the table itself. If you have migrated from a release < 7.6 (either directly or by recovering from a backup) chances are that the counter values in FILES have not yet been initialized. In that case you're back to your original problem or you will have to wait for the next release where the counters in FILES will be initialized automatically in the background. Best wishes, Martin. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
