We keep track of deletes and inserts. Whenever we hit about 3% delete or insert we rebuild.

-----Original Message-----
From: Gil Edmund
[mailto:oracledba-ezmlmshield-x91753133.[Email address protected]
Sent: Friday, January 27, 2006 11:21 AM
To: LazyDBA Discussion
Subject: How to re-index SQL Database


Hey everyone,

when would you rebuild your indexs in SQL and how would you go about doing this?


THANKS

Edmund Gil,
Oss Team Lead

Moneris Solutions
A Royal Bank/Bank of Montreal Joint Investment
Clarica Centre · 3300 Bloor Street West, 4th Floor West Tower
Toronto, Ontario, M8X2X2
*Phone: (416)-734-1170 | *Cell: (416)-904-8115
*email: edmund.[Email address protected]
Wireless:edmund.[Email address protected]



_______________________________________________________________________

This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations.
Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized.
If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately.

Ce courrier électronique est confidentiel et protégé. L'expéditeur ne renonce pas aux droits et obligations qui s'y rapportent.
Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) désigné(s) est interdite.
Si vous recevez ce courrier électronique par erreur, veuillez m'en aviser immédiatement, par retour de courrier électronique ou par un autre moyen.


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


-----------------------------------------
CONFIDENTIALITY NOTICE

This message and any attachments are from the NAIC and are intended
only for the addressee. Information contained herein is
confidential, and may be privileged or exempt from disclosure
pursuant to applicable federal or state law. This message is not
intended as a waiver of the confidential, privileged or exempted
status of the information transmitted. Unauthorized forwarding,
printing, copying, distribution or use of such information is
strictly prohibited and may be unlawful. If you are not the
addressee, please promptly delete this message and notify the
sender of the delivery error by e-mail or by calling the NAIC Help
Desk at (816)783-8500.


Oracle LazyDBA home page