MySQL Forums
Forum List  »  Performance

Re: drop and recreate index in mysql DB
Posted by: Ra Nala
Date: November 27, 2015 12:33AM

bwlow is my create table structure and I am trying to load data using one of the ETL tool called as PDI or Kettle(open source). Please ask me if you need more.

create table prd01_stg
(
psid bigint(20) not null,
pskey bigint(20) default -1 not null,
prod_srl_no varchar(200),
builddt datetime,
shipdt datetime,
invoicedt datetime ,
invoice_no varchar(100),
tenant_id bigint(20),
model_id bigint(20),
model varchar(50),
prod_cat_name varchar(100),
brand_name varchar(250),
prod_name varchar(250),
shbid bigint(20),
shbcode varchar(50),
shbtype_code varchar(50),
shbname varchar(250),
ibecode varchar(50),
ibetype_code varchar(50),
ibename varchar(250),
prod_rid bigint(20),
status_code varchar(50),
rtype varchar(50),
cust_deliverydt datetime,
rdate datetime,
rreference varchar(100),
rsource varchar(100),
rindustry varchar(50),
rapplication varchar(50),
invoice_customer_reference varchar(100),
rinvoice_no varchar(100),
sales_person varchar(255),
cbecode varchar(50),
cbetype_code varchar(50),
cbename varchar(250),
ca_1 varchar(100),
ca_2 varchar(100),
ca_3 varchar(100),
createddt datetime,
updateddt datetime,
od_createddt datetime,
od_updateddt datetime,
constraint pk_prd01_stg primary key (psid)
)
;

create table prd01
(
pskey bigint(20) not null,
psid bigint(20) not null,
prod_srl_no varchar(200),
builddt datetime,
shipdt datetime,
invoicedt datetime ,
invoice_no varchar(100),
tenant_id bigint(20),
model_id bigint(20),
model varchar(50),
prod_cat_name varchar(100),
brand_name varchar(250),
prod_name varchar(250),
shbid bigint(20),
shbcode varchar(50),
shbtype_code varchar(50),
shbname varchar(250),
ibecode varchar(50),
ibetype_code varchar(50),
ibename varchar(250),
prod_rid bigint(20),
status_code varchar(50),
rtype varchar(50),
cust_deliverydt datetime,
rdate datetime,
rreference varchar(100),
rsource varchar(100),
rindustry varchar(50),
rapplication varchar(50),
invoice_customer_reference varchar(100),
rinvoice_no varchar(100),
sales_person varchar(255),
cbecode varchar(50),
cbetype_code varchar(50),
cbename varchar(250),
ca_1 varchar(100),
ca_2 varchar(100),
ca_3 varchar(100),
createddt datetime,
updateddt datetime,
od_createddt datetime,
od_updateddt datetime,
constraint pk_prd01 primary key (pskey)
)
;
create index inx_psid on prd01 (psid)
;
create index inx_prod_rid on prd01 (prod_rid)
;
create index inx_shbid on prd01 (shbid)
;

Options: ReplyQuote


Subject
Views
Written By
Posted
1649
November 25, 2015 05:48AM
980
November 26, 2015 02:31PM
Re: drop and recreate index in mysql DB
1529
November 27, 2015 12:33AM
1727
November 29, 2015 11:38AM
1217
November 30, 2015 01:34AM


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.