Brad, We have a client with over 3 million records with 14 indices running on Unidata 7.2. We have never rebuilt the indexes in over two years. The last time we rebuilt them we added some 2 more indexes. We just purged about a 1/2 million records with no problems on the indexes that are used everyday from our Web data entry and reports forms.
Regards, Doug www.u2logic.com -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: Thursday, July 16, 2009 2:07 PM To: U2 Users List Subject: Re: [U2] More questions on indexing I think Oracle's indexing scheme is much more complicated that Unidata's, so I don't think you can compare the two. I do rebuild some of the dynamic files on occasion to get some space back. Other than that, I leave them alone and haven't had problems. - Rod -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Thursday, July 16, 2009 3:00 PM To: U2 Users List Subject: [U2] More questions on indexing Research continues and I have more question for the group: my Oracle buddies rebuild their indexes at least weekly. Seems to be a best practice. Seems odd to not be able to trust that your index is correct. Is this a concern for ud 7.1? TIA, Brad. ud 7.1 AIX 5.3 U.S. BANCORP made the following annotations --------------------------------------------------------------------- Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. --------------------------------------------------------------------- _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users ---------------------------------------------------------------------------- -- CONFIDENTIALITY NOTICE: If you have received this email in error, please immediately notify the sender by e-mail at the address shown. This email transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. Copyright 2009 CIGNA ============================================================================ == _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
