title: Does using union or joins in query causes slower performance in Sphinx?
body: <p>I am willing to use <strong>sphinx with MySQL</strong> for my current project.
  <strong>MYISAM as database engine</strong> as this db is gonna be only <strong>read-only</strong> with <strong>10-25 millions of records</strong>.</p>
  
  <p>so i would like to know whether , 
  <strong>Does using union or joins in query causes performance issues in Sphinx ?</strong></p>
  
  <p>as i am about to design database and if union/joins gonna cause the slower performance then i can go for optimized design for sphinx. </p>
  
  <p>Maybe like creating one big table with all fields and data and then creating <strong>separate INDEXES</strong> in sphinx depending on the data to be searched.</p>
  
  <p>please guide me in correct direction.</p>
  
  <p>thanks for your time.</p>