Wildcard on index loopkups

Mike Schwartz (PC Support) mschw at athenet.net
Mon Oct 3 10:58:59 PDT 2005


> 
> You say you'd rather not have an additional index built on the field
> that you are trying to use here, but you have to ask yourself if the
> reasons for not building an additional index outweight all of the extra
> work needed to get around this lack of index is worth it.  Even with
> two million records, once the index is built, you're not talking about
> very much overhead for a 10-character field.
> --
> KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>

    There are other circumstances, such as there are numerous servers
running this app around the country, the database is in use 24x7, except for
a couple of hour backup window at 2:00AM on Sunday Morning, and TPTB* do not
want to permit me to build the additional index.  Otherwise I wouldn't be
looking for a crazy work around.

Mike

*The Powers That Be...




More information about the Filepro-list mailing list