If you are doing it because of performance, I am thinking you need to re-size the file (as you suggested). This will not just impact SELECTS, but any IO. Also keep in mind you are impacting performance just by having the index. All that being said, getting the time to resize is something that can be limited by the nature of your business.
Just some points to consider. You know your business better than the rest of us. JRI -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, May 24, 2013 10:57 AM To: U2 Users List Subject: Re: [U2] UV File doesn't like being sampled? In thinking about it....I'm not sure, but it seems to increase the selection speed (considerably). It is a type 30 file, So possibly the index makes up for a hashing algorithm where the modulo is too small? And the makeup of The @ID causing more similar hashing? -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Friday, May 24, 2013 10:52 AM To: U2 Users List Subject: Re: [U2] UV File doesn't like being sampled? Maybe I am missing something, but why would you want an index on @ID? JRI -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, May 24, 2013 10:18 AM To: U2 Users List Subject: Re: [U2] UV File doesn't like being sampled? YUP. I just isolated it to the index of @ID. I changed the original filename, recreated a new file Copied all the data Copied all the dict And finally, recreated the index (@ID) Testing the sampling on each step, all went well until I recreated the index, then it bombed again. And yes, using the NO.INDEX does fix it. Does working with an active select list de-activate the @ID Index? George _______________________________________________ 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
