Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Location
    Australia
    Posts
    2

    Post Unanswered: Matches in VARCHAR fields

    Hi Guys,

    I have a table with 300,000 rows in it, and a field Col1 which is a VARCHAR(100). I have a LIKE query that searches this and the slow query log file picks up this query (query time of 1).

    Is there a way to optimise this?? I have tried FULLTEXT (match and against) but this is only matching full word matches, not part word matches.

    Thanks in advance.

  2. #2
    Join Date
    Nov 2002
    Location
    Ohio
    Posts
    90
    You could establish an index on the field.

    It should search faster, but it may decrease the speed of other operations to maintain another index.

    Good Luck,
    Bruce Baasch

  3. #3
    Join Date
    Nov 2002
    Location
    Australia
    Posts
    2
    Originally posted by Bruce A. Baasch
    You could establish an index on the field.

    It should search faster, but it may decrease the speed of other operations to maintain another index.

    Good Luck,
    There is already an index on the field. I don't know what to do!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •