index vs fultext
I' m confussed... In mysql there are three types of indexes (i think):
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
Maybe a person would have a column of keywords.