title: Will a FULLTEXT index on a join column fast the query in MySQL?
body: <p>I am new to this fulltext index and what I know is that the fulltext is used to index text or varchar columns to fast searches.</p>
  
  <p>I have also read that fulltext indexes are used only with (MATCH...AGAINST) synthax? Is that true?</p>
  
  <p>My question was: if I use a fulltext index on a column, will it fast the query or not?</p>
  
  <p>The query is:</p>
  
  <p>SELECT *
  FROM table1 a
  INNER JOIN table2 b
  ON a.text = b.text;</p>
  
  <p>fulltext index is set for column text for both tables.</p>
  
  <p>Thanks.</p>
  
  <p>Best Regards,</p>