MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: Help with index in a view. Index not used. MySql Bug?
Posted by: Rick James
Date: April 04, 2009 10:11PM

(Sorry, I'm going to avoid your question.)
You could insert two rows each time a friendship is established -- a->b and b->a. That would get rid of the need for the UNION. And that would double the speed of the view. And avoid the issue you are raising.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Help with index in a view. Index not used. MySql Bug?
6422
Emilio Nicolás
April 01, 2009 03:02AM
Re: Help with index in a view. Index not used. MySql Bug?
3362
Emilio Nicolás
April 02, 2009 02:26AM
Re: Help with index in a view. Index not used. MySql Bug?
3245
Rick James
April 04, 2009 10:11PM
Re: Help with index in a view. Index not used. MySql Bug?
3158
Emilio Nicolás
April 05, 2009 01:08PM
Re: Help with index in a view. Index not used. MySql Bug?
3333
Emilio Nicolás
April 06, 2009 04:20PM


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.