You can turn on Auto Stats Update in Oracle 9i & set the rebuild threshold.
This seems to work pretty well in the shops I've been at. Look it up in the
docs & try it out. . Good Luck:-)

Sincerely,
Charlotte L. Harris, Senior Consultant
MBH Solutions, Inc.
AQMD (909) 396-2891
Cell (702) 835-3303 & Home (702) 617-2502
Fax (702) 617-1357


Quoting Chris <mssqldba-ezmlmshield-x49972612.[Email address protected]

> David-
>
> Here's an example from the 9i docs...
>
> ALTER INDEX ord_customer_ix REBUILD;
>
> There are several variations so you might want to review your documentation
> prior to using it.
>
> BTW- This the MSSQL group
>
> Thanks
> Chris
>
>
>
> -----Original Message-----
> From: David Neff
> [mailto:mssqldba-ezmlmshield-x14736890.[Email address protected]
> Sent: Friday, March 31, 2006 8:51 AM
> To: LazyDBA Discussion
> Subject: fully understanding that this is a SQL group,
>
>
> does anyone know if you can rebuild indexes in Oracle on line without
> impacting the users?
>
>
>
> David Neff
>
>
>
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
> --
> This message has been scanned for viruses and dangerous content by
> MailScanner, and is believed to be clean.
>
> Douglas County, Oregon
> www.co.douglas.or.us
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>

MS Sql Server LazyDBA home page