title: Why is this Azure SQL query extremely slow?
body: <p>I have a small table with about 1 Million rows and I am running the following query against it.</p>
  
  <pre><code>SELECT *
  FROM TillBasicData
  WHERE companyid = 'BE_AA'
  AND languagecode = 'eng'
  AND noos14 LIKE '%09258384374953%';
  --09258384374953,09258387354952
  </code></pre>
  
  <p>The problem is that it takes close to 1 minute to execute.</p>
  
  <p>I added the following index to try and speed things up</p>
  
  <pre><code>CREATE INDEX IX_TillBasicData
      ON dbo.tillbasicdata (companyid DESC, languagecode DESC, noos14 DESC);
  </code></pre>
  
  <p>This helps a bit and takes it down to about 30 seconds but I still don't get why it takes so long, I can only assume it has to do with the LIKE statement but what can I do to speed things up?</p>
  
  <p>On such a small table I would assume the query to execute in less than 1 second.</p>