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 1982 angel rivero 07/07/2011 02:14AM
Re: Time performance in query Inner Join 567 Peter Brawley 07/07/2011 06:39AM
Re: Time performance in query Inner Join 681 angel rivero 07/07/2011 09:47AM
Re: Time performance in query Inner Join 548 Peter Brawley 07/07/2011 01:10PM
Re: Time performance in query Inner Join 495 Rick James 07/07/2011 10:29PM
Re: Time performance in query Inner Join 742 angel rivero 07/08/2011 06:52AM
Re: Time performance in query Inner Join 935 angel rivero 07/08/2011 07:03AM
Re: Time performance in query Inner Join 542 Rick James 07/08/2011 09:07PM
Re: Time performance in query Inner Join 510 angel rivero 07/09/2011 07:16AM
Re: Time performance in query Inner Join 518 Rick James 07/09/2011 10:49AM
Re: Time performance in query Inner Join 487 angel rivero 07/09/2011 01:09PM
Re: Time performance in query Inner Join 737 Rick James 07/09/2011 04:54PM
Re: Time performance in query Inner Join 500 angel rivero 07/10/2011 01:59AM
Re: Time performance in query Inner Join 465 Rick James 07/10/2011 12:19PM
Re: Time performance in query Inner Join 1225 angel rivero 07/10/2011 01:55PM
Re: Time performance in query Inner Join 551 Rick James 07/10/2011 04:28PM
Re: Time performance in query Inner Join 425 angel rivero 07/11/2011 03:01AM
Re: Time performance in query Inner Join 479 Rick James 07/11/2011 11:28AM
Re: Time performance in query Inner Join 481 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.