[EMAIL PROTECTED] wrote > after migrating from 7.3.0.29 to 7.4.3.10 the command > > dbmcli -u dbm,dbm -d MYDB -uSQL -c info state shows the > following output : ... > Bad Indexes = 157 ... > Before the migration there were definitely no Bad Indexes. So > how do I recover > from this ?
With 7.4 we changed the index handling to straighten up the code a little bit. Unfortunately this makes it necessary to recreate single indexes if they are defined on optional columns (insertion of NULL is allowed). You could use dbmcli command 'sql_recreateindex' or 'DBMGui -> Tuning -> Index Use' to do so. Sorry for any inconvenience. Kind regards, Holger SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
