MySQL Forums
Forum List  »  MyISAM

Advanced Search
New Topic

Re: Fulltext search with order by using filesort
Posted by: Torsten
Date: January 02, 2006 12:25PM

Hi,

I tried almost everything but it does not use the index on m_tstmp. Mysql uses the fulltextindex on subject and body like expected but can't be combined with a second index on m_tstmp. To put the m_tstmp column in the fulltextindex does not make sense because it tampers the search score.

Torsten

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Fulltext search with order by using filesort
4742
Torsten
December 30, 2005 12:37PM
Re: Fulltext search with order by using filesort
2698
Brian Moon
January 01, 2006 12:19PM
Re: Fulltext search with order by using filesort
2985
Torsten
January 02, 2006 12:20PM
Re: Fulltext search with order by using filesort
2289
Ingo Strüwing
January 02, 2006 06:08AM
Re: Fulltext search with order by using filesort
2249
Torsten
January 02, 2006 12:25PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.