Re: Tunning Indexes

"Javier Villegas" <mask_at_impsat1.com.ar> wrote in message news:<YT1Sa.5756$Uc5.4404_at_fe06.atl2.webusenet.com>...
> HI.
>
> I have tables that have a couple of indexes
>
> The table are growing
>
> I donīt know how can I improve the performance on the indexes (Defrag ,
> rebuild, etc)
>
> Could you tell me how can I do that ?
>
> thanks in advance

In most cases an index rebuild may clean-up space, but usually does not have a big impact on performance.

You can use the "alter index xxx rebuild;" command to rebuild them. Received on Sat Jul 19 2003 - 15:26:45 CDT