0

Hi, i have a Sql Server 2008 database, with a table that has around of 2.000.000 registers. The schema of the table is the following:

idSpecie (PK, int) | Kingdom | Phylum | Class | Order | Family | Genus | Specie

The kingdom, phylum, class, order, family, genus and specie columns are all varchar(50).
This table is fixed, and will never get any update/insert/delete, but it receives a lot of search queries in all of the columns. Is there a way to improve performance on these queries?

Thanks a lot!

Edited by _tincho87

2
Contributors
6
Replies
7
Views
5 Years
Discussion Span
Last Post by urtrivedi
0

Thanks for your reply, but the search queries are individual for each column, i mean "SELECT Phylum FROM [Table] WHERE Kingdom LIKE '%TEXT%'", the Full Text Search works for this too? ie this improves the performance?

Thanks!

0

Hi, i explored FullText indexes, but the table has duplicated values in some columns, and the fulltext index cannot be created. Is there other way to improve performance?

Thanks

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.