MySQL Forums
Forum List  »  InnoDB

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

hi

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


Subject
Views
Written By
Posted
Block Nested Loop
68
June 15, 2018 10:15AM
28
June 15, 2018 11:43AM


Sorry, only registered users may post in this forum.

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.