Re: drop and recreate index in mysql DB

[Ra Nala]

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)
;