Re: Up to 1 million rows Performance + Design Help
Posted by: dimitar nenchev
Date: May 18, 2009 09:49AM

Sorry i didn't undestand if Mysql will use the multi index by gener_id, movie_date when checks the movie table?

What i want is to use fulltext index and order the results using index too. If the keywords are in the movie table this is impossible, because Mysql will always use fulltext index and then do more work to sort the result. BUT if the keywords are in separate table, what? If it will use the multi index to get them ordered.

Options: ReplyQuote




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.