MySQL Forums
Forum List  »  Optimizer & Parser

difference between READ and SCAN
Posted by: Linhai Song
Date: June 20, 2012 04:05PM

hi,

I find that sometimes mysql will implement "select" by READ and sometimes mysql will implement "select" by SCAN.

What is the difference between READ and SCAN? And when mysql will use READ and when mysql will use SCAN?

I also do not understand what does ACC scan and TUX scan mean.

Thanks a lot!

Options: ReplyQuote


Subject
Views
Written By
Posted
difference between READ and SCAN
2200
June 20, 2012 04:05PM


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.