Skip navigation links

MySQL Forums :: Performance :: Time performance in query Inner Join


Advanced Search

Re: Time performance in query Inner Join
Posted by: angel rivero ()
Date: July 08, 2011 06:52AM

Rick James Wrote:
-------------------------------------------------------
> In addition to Peter's toned down request, ...
>
> Let's see the EXPLAIN for that SELECT.
> 
Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
_tbl1	InnoDB	10	Compact		3666243	210	771751936	0	874053632	1432354816	3669961	3/3/2011 16:51:51			latin1_swedish_ci			
_tbl2	InnoDB	10	Compact		9395	392	3686400	0	1310720	1432354816	9291	20/6/2011 14:43:38			latin1_swedish_ci


> ALTER TABLE _tbl2
> ADD INDEX(MCR_Cod, MCR_Clt, MCR_Den); 

[SQL] ALTER TABLE _tbl2 
ADD INDEX(MCR_Cod, MCR_Clt, MCR_Den);
Affected rows: 9290
Time: 1.741ms

In MySQL:
Affected rows: 0
Time: 82.387ms

In browser:
Affected rows: 0
Time: 124.113ms

thks

Options: Reply•Quote


Subject Views Written By Posted
Time performance in query Inner Join 1757 angel rivero 07/07/2011 02:14AM
Re: Time performance in query Inner Join 504 Peter Brawley 07/07/2011 06:39AM
Re: Time performance in query Inner Join 610 angel rivero 07/07/2011 09:47AM
Re: Time performance in query Inner Join 493 Peter Brawley 07/07/2011 01:10PM
Re: Time performance in query Inner Join 445 Rick James 07/07/2011 10:29PM
Re: Time performance in query Inner Join 679 angel rivero 07/08/2011 06:52AM
Re: Time performance in query Inner Join 766 angel rivero 07/08/2011 07:03AM
Re: Time performance in query Inner Join 488 Rick James 07/08/2011 09:07PM
Re: Time performance in query Inner Join 451 angel rivero 07/09/2011 07:16AM
Re: Time performance in query Inner Join 462 Rick James 07/09/2011 10:49AM
Re: Time performance in query Inner Join 437 angel rivero 07/09/2011 01:09PM
Re: Time performance in query Inner Join 688 Rick James 07/09/2011 04:54PM
Re: Time performance in query Inner Join 453 angel rivero 07/10/2011 01:59AM
Re: Time performance in query Inner Join 394 Rick James 07/10/2011 12:19PM
Re: Time performance in query Inner Join 1038 angel rivero 07/10/2011 01:55PM
Re: Time performance in query Inner Join 505 Rick James 07/10/2011 04:28PM
Re: Time performance in query Inner Join 368 angel rivero 07/11/2011 03:01AM
Re: Time performance in query Inner Join 421 Rick James 07/11/2011 11:28AM
Re: Time performance in query Inner Join 411 angel rivero 07/12/2011 10:22AM


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

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.