Post reply

Keyword Search Across Mult. Columns

  • July 9, 2002 at 3:51 pm

    #101189

    I have a keyword search against a table that has around 10000 records. Many( about 2000) are duplicated due to the fact they are coming from an extract from a HP image dB. anyway, is it best to do a distinct, group by, or view, cursor, performance wise? i will be doing some scripting against the search term to see if it is numeric and so forth but it will be searching

    name varchar(100)

    desc. varchar(3000)

    keywords varchar(1000)

    size varchar(25)

    color varchar(25)

    thanks-chris


    </cm>

  • July 9, 2002 at 4:51 pm

    #432294

    I would use Distinct myself...

    quote:

    I have a keyword search against a table that has around 10000 records. Many( about 2000) are duplicated due to the fact they are coming from an extract from a HP image dB. anyway, is it best to do a distinct, group by, or view, cursor, performance wise? i will be doing some scripting against the search term to see if it is numeric and so forth but it will be searching

    name varchar(100)

    desc. varchar(3000)

    keywords varchar(1000)

    size varchar(25)

    color varchar(25)

    thanks-chris

    Michael Weiss


    Michael Weiss

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

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