Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 3 of 3 total |
OPTIMIZE TABLE aaa USEING INDEX bbb |
Tue, Nov 27 2007 2:13 PM | Permanent Link |
Abdulaziz Jasser | 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 |
Wed, Nov 28 2007 8:45 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Wed, Nov 28 2007 2:20 PM | Permanent Link |
Abdulaziz Jasser | 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 |
This web page was last updated on Sunday, May 5, 2024 at 10:18 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |