MySQL Forums
Forum List  »  InnoDB

Re: performance issue even i have index on my columns
Posted by: Ra Nala
Date: December 17, 2017 10:29AM

SiR
Below it is, hope it is helpful if not please ask me if required another info. thank you.


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,
tid 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_tid (tid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: performance issue even i have index on my columns
27
December 17, 2017 10:29AM


Sorry, only registered users may post in this forum.

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.