Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2003
    Location
    Holland
    Posts
    8

    Unanswered: Indexing a TEXT Column

    Hey

    I want to index a TEXT column to accelerate my searchfunction,
    does anybody have experience or good idea's ??

    Greetz Da Witte

  2. #2
    Join Date
    Oct 2003
    Posts
    11

    Cool

    Hi,
    Try index tuning wizard..
    It will tell you if you should create an index and helps you do that.
    Create a workload file and run it thru index tuning wizard..

    Good luck
    Tommy
    Tsz

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Text and image columns cannot be indexed. Use a long VARCHAR datatype instead.

    blindman

  4. #4
    Join Date
    Oct 2003
    Posts
    11

    Cool

    Good point Blindman !! :-)
    Tsz

  5. #5
    Join Date
    Oct 2003
    Location
    Holland
    Posts
    8
    Originally posted by blindman
    Text and image columns cannot be indexed. Use a long VARCHAR datatype instead.

    blindman
    Problem... I want to store >1000000 characters and also want to search in those records !!

  6. #6
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Look up Full-Text Indexes in Books Online. I think it will do what you are looking for.

    blindman

Posting Permissions

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