Hi,

This is my first time to use "OPTIMIZE TABLE aaa USEING INDEX bbb" clause and I am having a difficulty finding the right syntax!!!  The following
statement works:

OPTIMIZE TABLE TB_AccountBalances;

But if I add "USING INDEX" I get an error:

OPTIMIZE TABLE TB_AccountBalances USING INDEX BranchSysNo;

"BranchSysNo" is a field that has an index with the same name.  I tried other tables with other indexes and they all fails.  This shouldn't be hard!  So
what is missing here?  I use 1.06 B1

Abdulaziz,

<< But if I add "USING INDEX" I get an error:

OPTIMIZE TABLE TB_AccountBalances USING INDEX BranchSysNo; >>

The manual is incorrect, it should read:

OPTIMIZE TABLE <TableName>
[USING <IndexName>]

--
Tim Young
Elevate Software
www.elevatesoft.com

Ahhhhhhhhhhhhhhhhhhhhhhhhh.....



"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Abdulaziz,

<< But if I add "USING INDEX" I get an error:

OPTIMIZE TABLE TB_AccountBalances USING INDEX BranchSysNo; >>

The manual is incorrect, it should read:

OPTIMIZE TABLE <TableName>
[USING <IndexName>]

--
Tim Young
Elevate Software
www.elevatesoft.com