>
> How often do they do a gbak and restore?
>

Is it not enough just to do a sweep every nigth to have the
transactions cleaned up ?

>
> >Could the size of the table (~1M recs) significantly affect the

speed of

> >returning records read by index?
>
> It could. How often do they run SET STATS to rebalance the indexes?

Is this something that should be done every once in a while ?
What does it do



Regards
Michael