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
1467
June 15, 2018 10:15AM
729
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.