Member Avatar for _tincho87

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
  • 164 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by urtrivedi
Member Avatar for urtrivedi

EXPLORE FULL TEXT SEARCH IN MSSQL

Member Avatar for _tincho87

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!

Member Avatar for urtrivedi

Yes it has good features, just explore it.

Edited by urtrivedi
Member Avatar for _tincho87

great! thanks!

Member Avatar for _tincho87

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.