MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: Attempt to split big table into smaller one made query slower
Posted by: Patrick St.Onge
Date: March 15, 2010 09:40AM

thank you for all the suggestions, it'll take a while before I can try them out.

I have a couple questions though. About the indexes, what is the advantage of indexing two columns together? I also noticed that you have dateAdded twice. What is the reason for this? Also, how will the indexes in both tables be used at the same time when they have different columns indexed?

Can you explain the concept of normalizing keywords? I've never seen the <=> operator in MySQL.

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




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.