[SQL] Reindex database versus Reindex each table

[Ruslan Zasukhin]

On 6/6/05 3:16 PM, "Francois Van Lerberghe" <fvanlerberghe at freegates.be>
wrote:

> Hello all,
> 
> I'm using V4RB 1.11 with Relabasic.
> 
> Is there a difference between the SQL command "REINDEX DATABASE" and the
> command "REINDEX TABLE tablename" done on each table of the database ?

In general no, although REINDEX DATABASE also reindex system tables.


> If it's the same, I tend to prefer doing this on each table to give the user
> a visual return of the progress

You can self reindex system tables also.
    They have names sysItems and sysItemDescription


 
> And doing this, must I also perform the reindex on the baseobjects
> "sysItemDescription" and "sysItem"

To be the same yes

 
> Thank you to enlight me on this subject.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]