Hello, all. I'm having a little trouble with the TABLESTATISTICS table in MaxDB 7.6.0.16. If I select * from TABLESTATISTICS, I can see only tables whose schema matches the connected user. Even if the connected user has permission to select from tables in another schema, the connected user still can't see those tables listed in TABLESTATISTICS.
The behavior becomes a problem when there are tables in a schema created by the CREATE SCHEMA statement, and the name of that schema doesn't match any actual user. When that happens, you can't see the aforementioned tables listed in TABLESTATISTICS at all. So, how do I get at the information that I would've pulled from TABLESTATISTICS? Thanks, Mark Thomas -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]