MySQL Forums
Forum List  »  Optimizer & Parser

Re: Log Query not using indexes
Posted by: Maciej Nadolski
Date: May 11, 2008 11:38PM

Your arent narrowing your query (select * from familie).
So it can't use index, it must do full scan to fetch all rows, ever.
So you aren't using indexes.
So your query is logged as souch not using indexes.

--
Best regards,
Maciej Nadolski

Options: ReplyQuote


Subject
Views
Written By
Posted
6272
April 09, 2008 10:07AM
Re: Log Query not using indexes
3009
May 11, 2008 11:38PM
2615
September 27, 2008 10:24PM
2929
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.