SitePoint Sponsor |
|
User Tag List
Results 1 to 2 of 2
Thread: index vs fultext
Hybrid View
-
Aug 6, 2003, 17:00 #1
- 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
-
Aug 7, 2003, 05:57 #2
- 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