SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Hybrid View

  1. #1
    SitePoint Member
    Join Date
    Aug 2003
    Location
    scotland
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    index vs fultext

    I' m confussed... In mysql there are three types of indexes (i think):

    1. primary
    2. index
    3. fulltext

    Primary will uniquely identify a row. This is clear. But index and fulltext are not. Fulltext is for optimising natural language search for certain words or groups of word that appear in a certain column provided they appear less than 50% of the time... correct? Index would be ideal for optimising a column for telephone numbers... correct?

    But which would you use for column of single words... eg street names.

    And??? It would seem that it is possible to to use fulltext and normal indexes for one single column... why would anyone do this

    Thanks in advance

    A confused beginner

  2. #2
    SitePoint Zealot basicwebus's Avatar
    Join Date
    Jul 2003
    Location
    Missouri
    Posts
    127
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Maybe a person would have a column of keywords.
    After the third time of reading the instructions,
    it finally soaks in to my thick skull.




Bookmarks

Posting Permissions

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