Posted by Manfred Sorg on 11/28/07 15:30

On 28 Nov., 01:12, Don Li <tatata9...@gmail.com> wrote:
> rows took about 7000ms. And I even added index hint. It's odd though
> yesterday and the day before yesterday, the same query ran at least
> 100% faster.

The question is: What has happened?
Did anyone create a trigger onto your table?
That's a good guess if inserted takes suddenly much longer.

Bye, Manfred

[Back to original message]