Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread Optimize
Sun, Mar 18 2007 8:49 PMPermanent Link

"Al Vas"
Hi,

I know you can call OptimizeTable using DBISAMTable but is there an Optimize
option in straight SQL?

Thanks

Alex

Mon, Mar 19 2007 6:20 AMPermanent Link

"Jose Eduardo Helminsky"
Al

According with manual and help:
OPTIMIZE TABLE [IF EXISTS] table_reference [ON index_name] [NOBACKUP]

Eduardo

Mon, Mar 19 2007 10:58 PMPermanent Link

"Al Vas"
Hi Jose,

think that must be V4 up.  Doesnt appear to work with V3 unless i have
syntax incorrect

Alex

"Jose Eduardo Helminsky" <contato@hpro.com.br> wrote in message
news:62EC2AF7-C8FA-4786-ADBA-D053251F766A@news.elevatesoft.com...
> Al
>
> According with manual and help:
> OPTIMIZE TABLE [IF EXISTS] table_reference [ON index_name] [NOBACKUP]
>
> Eduardo
>

Tue, Mar 20 2007 6:24 AMPermanent Link

"Jose Eduardo Helminsky"
Al

AFAIK, yes, it only works with v4 Frown

Eduardo

Fri, Mar 23 2007 8:21 PMPermanent Link

"Al Vas"
Thanks Eduardo, one day somewhere somehow we'll find a space in time to
upgrade our apps to V4.  Just used the table-driven method in the meantime

Alex

"Jose Eduardo Helminsky" <contato@hpro.com.br> wrote in message
news:A49D662D-AAC0-4724-9D1E-C67F2A6BAF41@news.elevatesoft.com...
> Al
>
> AFAIK, yes, it only works with v4 Frown
>
> Eduardo
>
>

Image