title: Sorting rows of table permanently in a SQL Server CE database
body: <p>I have a database which has a table named <code>dictionary</code> and it has 2 columns named <code>english</code> and <code>bangla</code>. The table contains about 70,000 rows. I want to sort the data according to <code>english</code> column alphabetically.</p>
  
  <p>I know how can sort them in a SQL query:</p>
  
  <pre><code>SELECT english, bangla
  FROM dictionary
  ORDER BY english
  </code></pre>
  
  <p>But it just shows as I queried. It doesn't effect permanently on database.</p>
  
  <p>What I want is to sort the database permanently.</p>
  
  <p>How can I do that???</p>
  
  <p>Another question:</p>
  
  <p>I have about 70,000 rows and when I perform a search query in my windows app the searching result is very slow. If I sort the database alphabetically, will the search become faster???</p>