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: ReplyQuote


Subject Views Written By Posted
Time performance in query Inner Join 2054 angel rivero 07/07/2011 02:14AM
Re: Time performance in query Inner Join 580 Peter Brawley 07/07/2011 06:39AM
Re: Time performance in query Inner Join 696 angel rivero 07/07/2011 09:47AM
Re: Time performance in query Inner Join 561 Peter Brawley 07/07/2011 01:10PM
Re: Time performance in query Inner Join 512 Rick James 07/07/2011 10:29PM
Re: Time performance in query Inner Join 761 angel rivero 07/08/2011 06:52AM
Re: Time performance in query Inner Join 973 angel rivero 07/08/2011 07:03AM
Re: Time performance in query Inner Join 560 Rick James 07/08/2011 09:07PM
Re: Time performance in query Inner Join 532 angel rivero 07/09/2011 07:16AM
Re: Time performance in query Inner Join 528 Rick James 07/09/2011 10:49AM
Re: Time performance in query Inner Join 505 angel rivero 07/09/2011 01:09PM
Re: Time performance in query Inner Join 751 Rick James 07/09/2011 04:54PM
Re: Time performance in query Inner Join 517 angel rivero 07/10/2011 01:59AM
Re: Time performance in query Inner Join 482 Rick James 07/10/2011 12:19PM
Re: Time performance in query Inner Join 1245 angel rivero 07/10/2011 01:55PM
Re: Time performance in query Inner Join 567 Rick James 07/10/2011 04:28PM
Re: Time performance in query Inner Join 454 angel rivero 07/11/2011 03:01AM
Re: Time performance in query Inner Join 493 Rick James 07/11/2011 11:28AM
Re: Time performance in query Inner Join 498 angel rivero 07/12/2011 10:22AM


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.