MySQL Server Forum - Do I still need a "non-full-text" search index?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Do I still need a "non-full-text" search index?

Robert Oschler

2005-08-17, 9:23 am

I have a database table with a field that is indexed as a "full-text"
search, since I want the capabiity. However, I also want the ability to
quickly retrieve records from that table that are ins "sorted-order" by this
very same field.

Do I still need to create a "regular" non-full-text search index to have
this capability? Or will the "full-text" index be sufficient?

Thanks.

Sponsored Links