How do I use full-text indexing in SQL Server Compact


  • Hi,
    I'm new to SQL Server Compact, coming from MySQL and am wondering what is the best stategy to use full-text indexing within SQL Server Compact?

    What I need is the fastest way to search through large datasets.

    Do I just create specific full-text indices for the columns that I need (like I would do in MySQL), or are the some special techniques for SQL Server Compact, or as part of the .Net environment?

    I'm not sure, if it's relevant, but I'm working with version 3.5 inside Visual Studio 2008 using C#.

    any help or pointers are greatly appreciated!

    thanks a lot...
    Thursday, November 27, 2008 12:58 AM

All replies