Re: Avoiding rebuilding of indexes

Posted in 2000

Obnoxio The Clown — Thu, 26 Oct 2000 13:08:38 BST — source: Informix-list mailing list archive (1991-1998)

From: Jinu.Joseph@citicorp.com > >We operate on a database of size 22 GB. For operational efficiency and >speed it was suggested that the indexes be dropped and recreated on a >weekly basis. Now the problem is that this takes 7 hours, and we dont >have that much time. So there are two questions ; >1. Does the rebuilding on a weekly basis help. Possibly, but I'd only do it monthly. >2. Is there anyway to speed it up or avoid it. Rather run UPDATE STATISTICS. :-) _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.