Re: Time performance in query Inner Join
> Sorry but I'm newbie... I hope you understand...
You have frequented the Newbie forum more than anyone else in the last several months. It is time for you to graduate. (You are barely ahead of "aluminum risers", but he/she never seems to ask any MySQL questions.)
> SHOW CREATE TABLE _tbl1\G;
works fine from the mysql commandline program. What tool are you using? Try it without the "\G", which tells the commandline program to display the results vertically (which is often clearer in this forum).
> SHOW TABLE STATUS LIKE _tbl1\G;
You need the quotes --
SHOW TABLE STATUS LIKE '_tbl1' ;
> EXPLAIN SELECT _tbl1\G;
No, not just the table name, the entire select statement.
Start over.
Subject
Views
Written By
Posted
3251
July 07, 2011 02:14AM
902
July 07, 2011 06:39AM
1095
July 07, 2011 09:47AM
1008
July 07, 2011 01:10PM
891
July 07, 2011 10:29PM
1145
July 08, 2011 06:52AM
1846
July 08, 2011 07:03AM
944
July 08, 2011 09:07PM
996
July 09, 2011 07:16AM
1028
July 09, 2011 10:49AM
973
July 09, 2011 01:09PM
1239
July 09, 2011 04:54PM
890
July 10, 2011 01:59AM
852
July 10, 2011 12:19PM
1719
July 10, 2011 01:55PM
Re: Time performance in query Inner Join
947
July 10, 2011 04:28PM
943
July 11, 2011 03:01AM
1001
July 11, 2011 11:28AM
841
July 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.