Timo Denis wrote: > We are looking forward for a easy solution to get the total > row count of > all tables within a database, are there any system tables providing > this information; we do not want to sum all 'select count (*) from > <table>' statements!
Hi, try is with "update stat *" as superdba and then execute "select sum(DISTINCTVALUES) from optimizerstatistics where COLUMNNAME = 'TABLE STATISTICS'" This will show you the row count for all tables you have permision for. If you only need an estimation you could use "update stat * estimate sampe <int> percent". This will gather the statistics much faster but is less accurate. Kind regards, Holger SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
