title: How to make a faster query when joining multiple huge tables?
body: <p>I have 3 tables. All 3 tables have approximately 2 million rows. Everyday 10,000-100,000 new entries are entered. It takes approximately 10 seconds to finish the sql statement below. Is there a way to make this sql statement faster?</p>
  
  <pre><code>SELECT customers.name
  FROM customers
  INNER JOIN hotels ON hotels.cus_id = customers.cus_id
  INNER JOIN bookings ON bookings.book_id = customers.book_id
  WHERE customers.gender = 0 AND
  customers.cus_id = 3
  LIMIT 25 OFFSET 1;
  </code></pre>
  
  <p>Of course this statement works fine, but its slow. Is there a better way to write this code?</p>