Re: performance issue even i have index on my columns
Posted by:
Ra Nala
Date: December 18, 2017 12:09AM
Sir, below is the result. not sure what will be difference for old results to this one
Table Create Table
---------------- -----------------------------------------------------------
temp CREATE TABLE `temp` (
`id` bigint(20) DEFAULT NULL,
`type ` varchar(50) DEFAULT NULL,
`code ` varchar(100) DEFAULT NULL,
`tname ` varchar(250) DEFAULT NULL,
`date ` datetime DEFAULT NULL,
`date1 ` datetime DEFAULT NULL,
`tenant_id` bigint(20) DEFAULT NULL,
KEY `inx_id` (`id`),
KEY `inx_date ` (`date `),
KEY `inx_date1 ` (`date1 `),
KEY `inx_composite_index_id_type_code_name_start_end` (`id`,`type `,`code `,`tname `,`date `,`date1 `),
KEY `inx_tenant_id` (`tenant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
1 record(s) selected [Fetch MetaData: 250/ms] [Fetch Data: 0/ms]
[Executed: 12/18/17 6:06:22 AM GMT ] [Execution: 250/ms]