>I have 4 milion rows in this table (I counted the dbf but the memo with content in all rows).
>60% of the rows - 11 length.
>20% 12-32
>19.95% 33-58
>0.05% - 67
>
>I want to svae space.
>
>if its les 100 mb
> its not worth
>else
> its importent
>endif
>
>I need help with the set blocksize syntax.
You must create a brand new table in order to use a new blocksize. The blocksize in effect when a new table is created, stays fixed for this new table.
Set blocksize to 50
Use oldtable
copy to newtable
use
copy file newtable.* to oldtable.*
use oldtable exclusive
Index on..