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