title: Database: Should ids be sequential?
body: <p>I want to use an id as a primary key for my table. In each record, I am also storing an id from an other source, but these ids are in no way sequential.</p>
  
  <p>Should I add an (auto-incremented) column with a "new" id? It is very important that queries by the id are as fast as possible.</p>
  
  <p>Some info:</p>
  
  <ul>
  <li>The content of my table is only stored "temporary", The table gets often cleared (TRUNCATE) and than filled with new content.</li>
  <li>It's a sql-server 2008</li>
  <li>After writing content to the table, I create an index for the id column</li>
  </ul>
  
  <p>Thanks!</p>