Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Enhancement Requests and Suggestions » View Thread |
Messages 1 to 3 of 3 total |
CREATE TEXT INDEX SQL for DBISAM |
Mon, Mar 10 2014 4:50 PM | Permanent Link |
Markus Gnam | Hello Tim,
may it be possible to add CREATE TEXT INDEX (...) for DBISAM like ElevateDB with no need to alter the table? I assume this could improve the full text index generation speed compared to "ALTER TABLE <tablename> TEXT INDEX (...)". Best wishes, Markus |
Mon, Mar 10 2014 7:48 PM | Permanent Link |
Raul Team Elevate | On 3/10/2014 4:50 PM, Markus Gnam wrote:
> may it be possible to add CREATE TEXT INDEX (...) for DBISAM like ElevateDB with no need to alter the table? > I assume this could improve the full text index generation speed compared to "ALTER TABLE <tablename> TEXT INDEX (...)". Not sure but issue might be that in DBISAM there is no catalogue so anything table related is actually part of the table itself so whatever we call itself is there would be a need to alter the table. Raul |
Wed, Mar 19 2014 10:03 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Markus,
<< may it be possible to add CREATE TEXT INDEX (...) for DBISAM like ElevateDB with no need to alter the table? I assume this could improve the full text index generation speed compared to "ALTER TABLE <tablename> TEXT INDEX (...)". >> The table alteration code in DBISAM is smart enough to know that only the text index has changed, and that it only needs to update it, and not the rest of the table. Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Wednesday, August 14, 2024 at 03:12 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |