[SQL] Reindex database versus Reindex each table

Francois Van Lerberghe fvanlerberghe at freegates.be
Mon Jun 6 14:16:09 CDT 2005


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 ?
If it's the same, I tend to prefer doing this on each table to give the user
a visual return of the progress

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

Thank you to enlight me on this subject.

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



More information about the Valentina mailing list