RE: rebuilding indexes

I said might because I dont have a box I can easily test it on, but felt it should work. My linux box at home ended up getting infected by a Microsoft O/S in order to do some other stuff, so testing has become more problematic. Will >===== Original Message From "Arshad, Shehla" <SArshad@purolator.com> ===== >> -----Original Message----- >> From: William Rice [SMTP:ricew@operamail.com] >> Sent: Monday, April 17, 2000 3:16 PM >> To: David Palmer; informix-list >> Subject: RE: rebuilding indexes >> >> set <database object> disabled; >> set <database object> enabled; >> might achieve what you are trying to do. >> > [Arshad, Shehla] Might achieve or will achieve? We were doing >disable/enable indexes/constraints and were told that it doesn't re-build >any indexes or constraints. I would like to go back to this strategy if >someone can confirm that it actually re-builds the indexes. Thx. > >> Will >> >> >===== Original Message From "David Palmer" <palmerd@billings.k12.mt.us> >> ===== >> >In 7.3, are there other ways to rebuild indexes other than dropping and >> >re-creating them? >> > >> >- David >> >> ------------------------------------------------------------ >> This e-mail has been sent to you courtesy of OperaMail, as a free >> service from >> Opera Software, makers of the award-winning Web Browser, Opera. Visit >> us at >> http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free >> e-mail >> account is waiting at: http://www.operamail.com/ >> ------------------------------------------------------------ ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------