Hi Manuel, an index is updated automatically on every change to the underlying table. So it always reflects the current table content and there is no need to 'resynchronise' it with the table.
However, it is always a good idea to update your table statistics regularly. Best wishes, Martin. >-----Original Message----- >From: Manuel Reiter [mailto:[EMAIL PROTECTED] >Sent: Dienstag, 27. Dezember 2005 14:49 >To: maxdb@lists.mysql.com >Subject: Update of indices / How to > >Hi, our SAPDB / MAXDB slowed down time by time; As we work a lot with >indices, is there a command to update the indices or ist this done via >update statistics ? > > > >-- >MaxDB Discussion Mailing List >For list archives: http://lists.mysql.com/maxdb >To unsubscribe: >http://lists.mysql.com/[EMAIL PROTECTED] > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
