Post reply

which will giv eus the most performance

  • August 1, 2005 at 8:26 am

    #578538

    Is the clustered index on the Word or the RowID? (I assume the rowid is there simply to make a unique value

    If your search app is trying to find all docs that have the world 'Hello' in them, then the RowID has absolutely no bearing on anything you just want the doc numbers

    unless you are tracking whether the word appears x times in the document then the cobination of Word + Doc No would be the ideal candidate for a unique clustered index

    Taking innto account the above I'd say stick with what you have got but possibly change the indexing strategy

    Graham

  • August 1, 2005 at 8:41 am

    #578548

    I too would agree, if you do not already have a clustered index on the Word column, you should create it. This assumes that most (if not all) of your search queries against this table are word based and not document #.

    Additionally, you may want to consider using Full Text Search (FTS) and creating a FT Index on Rowid and FT-enable column word, so this will add more flexiblity to your word searching, specificly inflectional word searches.

    Thanks,

    John

    SQL Full Text Search Blog

    http://spaces.msn.com/members/jtkane/


    John T. Kane

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply