[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sapdb-general
Subject:    RE: Update of indices / How to
From:       "Kittel, Martin" <martin.kittel () sap ! com>
Date:       2005-12-27 14:51:15
Message-ID: EC317E72A424A84BB7CC33205D8D7DF1038BC55D () dewdfe20 ! wdf ! sap ! corp
[Download RAW message or body]

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:m.reiter@edireal.com] 
>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/maxdb?unsub=martin.kittel@sap.com
>
>

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=sapdb-general@progressive-comp.com


[prev in list] [next in list] [prev in thread] [next in thread]