fast search with SQL Server 2000 on varchar column

[Rajkamal_dfine]

Hi I am in the situation to write code to pull the data from a table which has 1 Million rows per day what are the optimal ways to search the text ? database : SQL Server 2000 I have index on the table The table is portioned nrk

[Wendelius]

Hi, Not necessarily optimal but this may interest you Full-Text Indexes[^] Another possibility is to create custom keyword based index table using triggers etc Hope this helps, MIka