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