Hi Michael,

First, I hope that as you go through the programs you are considering any SELECT-SQLs and their Rushmore requirements.

That said, the first question I would ask is: have the tables been PACKed. This would remove any index bloat that may exist (you seem to be focused on size).

Is the problem disk space or speed or something else?

Good luck,

JimN

>hi
>
>my boss hs me going through all of the prg's on our system to find out what index tags we can get rid of out our tables. i'm courius just if there is a way to calculate just how much space it's going to save doing this. my largest table is only 320mg and has 6 or 7 tags on it the cdx is only 86mg. Is it realy with 2 or 3 tags granted there are tables but none of that size.
>
>thanks