[SQL] Reindex database versus Reindex each table

[Francois Van Lerberghe]

le 6/06/05 15:17, Ruslan Zasukhin <sunshine at public.kherson.ua> a écrit :

>> 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 how can I do that with V4RB 1.11 ?

I've tried "REINDEX TABLE sysItemDescription" or "REINDEX TABLE sysItem" but
got an error 602 "Table not found".

François Van Lerberghe
Rue Thier Monty, 15 A
4570 Marchin
Belgique