title: MAX(Date) Query running very slow - MySQL
body: <p>The below query is running very slow as the table is very huge and I just want to select a max of date form the table, I have some id1,id2, and date column as PK. Any trick to fetch it faster?</p>
  <pre><code>SELECT DATE_FORMAT(DATE_SUB(MAX(Date), INTERVAL 2 DAY), &quot;%Y-%m-%d %H:00&quot;)  
  FROM mytable.
  </code></pre>
  <p>Thanks in advance.</p>
  <p>Regards,</p>
  <p>Vijay</p>