[SQL] Reindex database versus Reindex each table

[Ruslan Zasukhin]

On 6/7/05 2:12 PM, "Francois Van Lerberghe" <fvanlerberghe at freegates.be>
wrote:

>>> 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".

Interesting. The names looks to be correct.

Well, may be it not works in 1.x.

-- 
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]