From: BinLing Jin Date: April 30 2002 2:44pm Subject: How to estimate the cost of JOIN operator in MYSQL? List-Archive: http://lists.mysql.com/internals/3457 Message-Id: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Hello there, I am working on how to estimate the cost (the number of disk input and output) of JOIN operator in MySQL. Therefore, I need to know how the MySQL executes the JOIN operator with or without INDEX. Does MySql use "two-pass algorithm" to execute the JOIN operator? Looking forward to hearing from you soon!!! Thank you very much! Binling