MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: What is meaning of "func" in "ref" column of EXPLAIN plan
Posted by: Jørgen Løland
Date: August 05, 2011 01:29AM

Hi Leo,


The value of ref is the column name referenced [1]. Do you by any chance use a column named func in the join condition? Otherwise, please provide the query.

[1] http://dev.mysql.com/doc/refman/5.5/en/explain-output.html#explain_ref

Hope this helps,
Jørgen Løland
Software Engineer, MySQL, Oracle
jorgenloland.blogspot.com

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


Subject
Views
Written By
Posted
What is meaning of "func" in "ref" column of EXPLAIN plan
8139
Leo Hopkins
August 04, 2011 07:36AM
Re: What is meaning of "func" in "ref" column of EXPLAIN plan
3242
Jørgen Løland
August 05, 2011 01:29AM
Re: What is meaning of "func" in "ref" column of EXPLAIN plan
3336
Leo Hopkins
August 05, 2011 06:12AM
Re: What is meaning of "func" in "ref" column of EXPLAIN plan
3036
Jørgen Løland
August 08, 2011 05:01AM
Re: What is meaning of "func" in "ref" column of EXPLAIN plan
2245
Rick James
August 08, 2011 07:52PM


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.