MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: Help with index in a view. Index not used. MySql Bug?
Posted by: Emilio Nicolás
Date: April 02, 2009 02:26AM

Depending on what I have been studying on reference manual on http://dev.mysql.com/doc/refman/5.1/en/view-restrictions.html, MySQL is unable to use index on its underlying tables using the temptable algorithm. However it seems indexes can be used for views processed using the merge algorithm.

My question is, how can i know witch algorithm is being used in a determinated view? and am i able to change it in anyway?

Thanks again!

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?
3361
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.