title: MySQL vs SQL Server 2008 R2 simple select query performance
body: <p>Can anyone explain to me why there is a dramatic difference in performance between MySQL and SQL Server for this simple select statement?  </p>
  
  <pre><code>SELECT email from Users WHERE id=1
  </code></pre>
  
  <p>Currently the database has just one table with 3 users.  MySQL time is on average 0.0003 while SQL Server is 0.05. Is this normal or the MSSQL server is not configured properly?    </p>
  
  <p><strong>EDIT:</strong><br>
  Both tables have the same structure, primary key is set to <code>id</code>, MySQL engine type is InnoDB.<br>
  I tried the query with <code>WITH(NOLOCK)</code> but the result is the same.</p>