I have a product table with a description column. The table contains ~250 000 products. (It will be more in the future)

When i run this:

select id, title, link from products where description like '%red jeans%'

it takes ~4 minutes to get the result. This table only contains links to other websites so the table don't have any relations to the rest of the database.

What can we do to speed up the search? Use other azure feature? Create a new table with search words and join them with the products? Whats best to do?

(What we do is to download a rss feed of products, and add them to the table in the database. And then we let our users search for products)

Within Azure SQL Database, you would want to use Full-Text Search, which is planned, but not yet available.  Other alternatives are Azure Search, SQL Server in Azure Virtual Machines, and Luciene.

Codry - I'd like to learn more about your scenario, please email me at joseph.idziorek at microsoft dot com.

Within Azure SQL Database, you would want to use Full-Text Search, which is planned, but not yet available.  Other alternatives are Azure Search, SQL Server in Azure Virtual Machines, and Luciene.

Codry - I'd like to learn more about your scenario, please email me at joseph.idziorek at microsoft dot com.

• Proposed as answer by Joseph IdziorekMicrosoft employee Tuesday, February 10, 2015 1:59 PM

Within Azure SQL Database, you would want to use Full-Text Search, which is planned, but not yet available.  Other alternatives are Azure Search, SQL Server in Azure Virtual Machines, and Luciene.

Codry - I'd like to learn more about your scenario, please email me at joseph.idziorek at microsoft dot com.

• Proposed as answer by Joseph IdziorekMicrosoft employee Tuesday, February 10, 2015 1:59 PM