title: Sort order for sqlite index
body: <p>There is sort order when creating index for sqlite.  </p>
  
  <p><a href="https://sqlite.org/lang_createindex.html" rel="noreferrer">https://sqlite.org/lang_createindex.html</a></p>
  
  <blockquote>
    <p>Each column name or expression can be followed by one of the "ASC" or "DESC" keywords to indicate sort order.  </p>
  </blockquote>
  
  <p>So, there are three options: no-sort, ASC, DESC when creating index. Where is info about how I should use them? I cant find it. </p>
  
  <p>I guess, if I use ASC or DESC in queries, I should add them to index. But should I add them both if they are both in different queries? Or should I just don't set sort order and it will select it itself?</p>
  
  <p>What is a general rule for it?</p>