MySQL Forums
Forum List  »  InnoDB

Block Nested Loop
Posted by: Ra Nala
Date: June 15, 2018 10:15AM


we are using mysql 5.7.11 INNODB version and when i am running the query(explain plan), it is giving the warning as Using index; Using join buffer (Block Nested Loop)

Is this causes performance of my query.

I am not able to run my query and taking hours to complete it even though we have indexes on joined columns.

Please let me know, Block Nested Loop is causing the issue.

Thank you

Options: ReplyQuote

Written By
Block Nested Loop
June 15, 2018 10:15AM
June 15, 2018 11:43AM

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.