Well it seems that the "sql_recreateindex" command can do the work, if no table/index name is given, it will fix all BAD indexes. According to MaxDB docs:
The default value is all indexes that are flagged as "bad" Regards, Martin On 1/24/06, Martin Cordova <[EMAIL PROTECTED]> wrote: > Hi, I have a "massive" amout of 20 bad indexes in one instance (MaxDB > 7.6.0.16 on SuSE 10.0 + XFS). I will try to check if there is a > problem with the harddisk -using badblocks program but other > suggestions are welcome-, in the meantime I wonder if there is a > command to re-create all of them at once, using DBMCLI? or maybe a > system stored procedure? > > Regards, > Martin > -- > Dinamica - RADical J2EE framework > open source, easy and powerful > http://www.martincordova.com > -- Dinamica - RADical J2EE framework open source, easy and powerful http://www.martincordova.com -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
