Searching in heavy DATABASE

[GauravKP]

I m working in c# .net application with sql server 2005...I have requirement of 1:N search from a record of over 1,00,000 of entries. How can I optimize search.Please suggest me .

[The Man from U N C L E]

The most efficient search mechanism in SQL is to use a fulltext index. There's loads of stuff a google[^] search can give you on using a full text index.

If you have knowledge, let others light their candles at it. Margaret Fuller (1810 - 1850) www.JacksonSoft.co.uk

[Ashfield]

Make sure your table is properly indexed.

Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

[Lost User]

IMO, 100000 rows is definitely not a 'heavy database'. If you properly index your tables, search should be very fast.