Re: Tunning Indexes
From: Jitendra Patel <coldrainandsnow_at_lycos.com>
Date: 19 Jul 2003 13:26:45 -0700
Message-ID: <7610580f.0307191226.60c61067_at_posting.google.com>
Date: 19 Jul 2003 13:26:45 -0700
Message-ID: <7610580f.0307191226.60c61067_at_posting.google.com>
"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 - 22:26:45 CEST