Re: NAME_CONST slow down the query
Posted by:
Larry Ng
Date: August 17, 2015 03:25PM
mysql> SHOW CREATE TABLE udi_data.tblimx_tree_ref\G;
*************************** 1. row ***************************
Table: tblimx_tree_ref
Create Table: CREATE TABLE `tblimx_tree_ref` (
`MemberID` decimal(11,0) NOT NULL,
`SponsorID` decimal(11,0) DEFAULT NULL,
`Lft` decimal(10,0) DEFAULT NULL,
`Rgt` decimal(10,0) DEFAULT NULL,
`Cmt` varchar(20) DEFAULT NULL,
`TrkID` int(11) DEFAULT NULL,
PRIMARY KEY (`MemberID`),
KEY `SponsorID` (`SponsorID`) USING BTREE,
KEY `Rgt` (`Rgt`) USING BTREE,
KEY `Lft` (`Lft`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8
1 row in set (0.00 sec)
Subject
Views
Written By
Posted
5087
August 14, 2015 03:33PM
2240
August 16, 2015 12:35PM
Re: NAME_CONST slow down the query
2051
August 17, 2015 03:25PM
2145
August 17, 2015 03:44PM
1783
August 19, 2015 01:39PM
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.