title: How to introduce indexing to sqlite query in android?
body: <p>In my android application, I use <code>Cursor c = db.rawQuery(query, null);</code> to query data from a local sqlite database, and one of the <code>query</code> string looks like the following:</p>
  <pre><code>SELECT t1.* FROM table t1
  WHERE NOT EXISTS (
    SELECT 1 FROM table t2
    WHERE t2.start_time = t1.start_time AND t2.stop_time &gt; t1.stop_time
  )
  </code></pre>
  <p>however, the issue is that the query gets very slow when the database gets huge. Trying to look into introducing <code>indexing</code> to speed up the query, but so far, not been very successful, therefore, would be great to have some help here, as it's also hard to find examples for this for android applications.</p>