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 2158 angel rivero 07/07/2011 02:14AM
Re: Time performance in query Inner Join 601 Peter Brawley 07/07/2011 06:39AM
Re: Time performance in query Inner Join 716 angel rivero 07/07/2011 09:47AM
Re: Time performance in query Inner Join 589 Peter Brawley 07/07/2011 01:10PM
Re: Time performance in query Inner Join 531 Rick James 07/07/2011 10:29PM
Re: Time performance in query Inner Join 803 angel rivero 07/08/2011 06:52AM
Re: Time performance in query Inner Join 1031 angel rivero 07/08/2011 07:03AM
Re: Time performance in query Inner Join 578 Rick James 07/08/2011 09:07PM
Re: Time performance in query Inner Join 561 angel rivero 07/09/2011 07:16AM
Re: Time performance in query Inner Join 568 Rick James 07/09/2011 10:49AM
Re: Time performance in query Inner Join 528 angel rivero 07/09/2011 01:09PM
Re: Time performance in query Inner Join 792 Rick James 07/09/2011 04:54PM
Re: Time performance in query Inner Join 535 angel rivero 07/10/2011 01:59AM
Re: Time performance in query Inner Join 513 Rick James 07/10/2011 12:19PM
Re: Time performance in query Inner Join 1284 angel rivero 07/10/2011 01:55PM
Re: Time performance in query Inner Join 584 Rick James 07/10/2011 04:28PM
Re: Time performance in query Inner Join 479 angel rivero 07/11/2011 03:01AM
Re: Time performance in query Inner Join 530 Rick James 07/11/2011 11:28AM
Re: Time performance in query Inner Join 541 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.