MySQL Forums
Forum List  »  Optimizer & Parser

Re: Join Query Performance Problme
Posted by: johne doe
Date: February 02, 2012 06:47AM

I also just modified the table schema to not allow NULL values on any of the indexed columns.. No faster..

What i dont understand is that each query individually only returns 6000 rows and its a matter of combining them then using the join condition..


I also meant to say, i know that the correct schema format would be to have the stocksymbol use foreign key instead of duplicating the char column and joining on integers then instead of char columns but this was a design i cant change because of legacy reasons (crap i know).



Edited 1 time(s). Last edit at 02/02/2012 03:44AM by will fleury.

Options: ReplyQuote


Subject
Views
Written By
Posted
1891
February 01, 2012 06:51AM
983
February 01, 2012 11:14AM
1027
February 02, 2012 12:39AM
Re: Join Query Performance Problme
985
February 02, 2012 06:47AM
997
February 02, 2012 07:02PM
982
February 03, 2012 12:29AM
1226
February 03, 2012 11:27AM
993
February 04, 2012 10:39AM
1002
February 06, 2012 06:13AM
1158
February 14, 2012 06:08PM
1004
February 03, 2012 10:18AM


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.