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