oking for a specific incident within a large date
range. Since your query has a specific incident number, indexing
that field would probably help a lot.
Thanks for the help, Douglas. That was the ticket. We're back under a
second for queries now.
Mike Schienle, Custom Visuals
http://www.cu
-> AND Date<="2004-01-11" AND Incident=98996144;
Can someone clue me in how I might get the SELECT Budget query to
return in a similar time to the SELECT Date query? I tried adding an
index for Budget, knowing it shouldn't help, and it didn't. FWIW, the
Webpage field
