well...that was too easy. Really speeds things up. went from about 45 second searches to to almost instant, depending on the number of fields being searched.
Thanks to all for the responses George >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] Behalf Of Allen Egerton >Sent: Wednesday, March 09, 2005 12:26 PM >To: [email protected] >Subject: Re: [U2] Question on File indexing... > > >From: "George Gallen" <[EMAIL PROTECTED]> >Sent: Wednesday, March 09, 2005 11:39 AM >Subject: [U2] Question on File indexing... > > >> I need to setup some file indexing, I've not used the internal B tree >> indexes before, and I don't >> have my manuals with me today. >> >> What do I need to do to setup a file for indexing? >> I don't need any fancy indexing, just index on state and zip, about >> 200,000 items > >CREATE.INDEX MY.ADDRESS.FILE STATE ZIP NO.NULLS >BUILD.INDEX MY.ADDRESS.FILE STATE ZIP >------- >u2-users mailing list >[email protected] >To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
