Re: Log Query not using indexes
Posted by:
Rick James
Date: September 27, 2008 10:24PM
Or, perhaps...
First time you ran it, it had to get everything off disk.
The second time you ran it, it was cached in ram.
The first took longer than long_query_time, hence got in the slow log. The second did not.
Subject
Views
Written By
Posted
6271
April 09, 2008 10:07AM
3009
May 11, 2008 11:38PM
Re: Log Query not using indexes
2614
September 27, 2008 10:24PM
2928
September 28, 2008 04:49AM
2612
September 28, 2008 03:02PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.