Wildcard on index loopkups

[Jean-Pierre A. Radley]

Mike Schwartz (PC Support) propounded (on Mon, Oct 03, 2005 at 12:58:59PM -0500):
| > 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.
| 
|     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.

So why can't you build the index at 2:05 AM on Sunday?

-- 
JP