• Good article.  I have a question about the comment not to index free form text fields, though.  Does this mean not to index a name field at all (a concept I don't understand if a search is to be done on a name) or the name field should be a char type and not a varchar type?

    I also would be interested in more information on indexing datetime fields, as I do that quite often.

    John Deupree