In data Tue, 27 Apr 2004 08:26:14 +1000, hai scritto:

> Possibly it's the first thing that happens after some job the day before
> performed a lot of deletes or updates on the table. The first login next
> day cops all the garbage collection.
>
> If this is the case, could you leave an overnight job running that performs
> a select 1 from that_table, ends the transaction, then does a manual sweep?

I can check this.
More details: the query that seems to give problem is not the first but
probably is the first that selects on that large table. I mean, the login
is fast, it's the query that performs poorly.

> If you are on XP, I guess you know about the SystemRestore problem...
>

yes, system restore is disabled

many thanks
ciao