And System Description, chapter 7 (aka IBM doc 25126370.pdf) CREATE.INDEX BUILD.INDEX DELETE.INDEX LIST.INDEX ENABLE.INDEX DISABLE.INDEX SELECTINDEX
no more than 3 per file is better. > From: dangf...@hotmail.com > To: u2-users@listserver.u2ug.org > Date: Wed, 9 Sep 2009 17:43:53 -0400 > Subject: Re: [U2] Indexing > > System Description, chapter 4, starting on page 22. > > Be sure to "get" what NO.NULLS does; if you have a lot of fields with null > values, it makes your index lopsided and much less effective. Also, note > that each index on a file increases your writes by 1. We see a significant > throughput hit after 5 or 6 indices on a file. Also, compound selects are > often less efficient than actually doing multiple selects. > > Building indices means exclusive locks on the file, i.e., downtime. The > good news is that the builds are usually very quick. > > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bessel, Karen > Sent: Wednesday, September 09, 2009 5:24 PM > To: u2-users@listserver.u2ug.org > Subject: [U2] Indexing > > I am not a UV newbie by any means, but I've never used indexing, and I > need to know where to start, with reading to gain some knowledge on the > documentation. > > > > Any particular area of the IBM technical documentation that might be > particularly helpful to this noob to the wide world of indexing? > > > > Thanks! > > > > > > > > Karen Bessel > Software Developer > > Tyler Technologies, Inc. > 6500 International Parkway, Suite 2000 > Plano, TX 75093 > Phone: 972.713.3770 ext:6227 > Fax: 972.713.3780 > Email: karen.bes...@tylertech.com > Web: http://www.tylertech.com > > > > Tyler is proud to be the Platinum Sponsor of > The Court Technology Conference 2009 > Sept. 22-24, 2009 | Denver, CO > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users _________________________________________________________________ Windows Live: Keep your friends up to date with what you do online. http://windowslive.com/Campaign/SocialNetworking?ocid=PID23285::T:WLMTAGL:ON:WL:en-US:SI_SB_online:082009 _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users