Try indexing on client, time instead of time, client...
putting the equality condition on the first column of the index can make
it faster.
Else, analyze, increase your stats, etc...
On Mon, 16 May 2005 13:39:40 +0200, Ilya A. Kovalenko <[EMAIL PROTECTED]>
wrote:
Greetings,
How can I co
Greetings,
How can I control which indexes will or won't be used by query ?
I never think, that I'll need something like this.
Short version:
Simple SELECT query perfomance speeds up (10x-20x) after _removing_
one of indexes. Because (as EXPLAIN shows), after removing, query
switches
