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

Rick i have a question, if he separates the text columns(that eventually will be used for fulltext search) in table movie_keywords and separate the genres in other table geners, and puts gener_id in the movies table. How will be performed search by keyword + gener Mystery?
If he join the 2 tables.
select <fileds> from moves m, movie_keyword mk where m.move_id = mk.move_id and
MATCH(mk.keywords) AGAINST(...) and m.gener_id = 3 order by move_date limit 200, 24;

if there are index INDEX on gener_id, move_date on movies

is the query use fulltext for the first table and the INDEX from the moves table? :)

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.