Re: Disable single index instead of all indexes
Posted by:
Ra Nala
Date: February 18, 2016 05:34AM
Sir ,
We are using AWS CLOUD RDS machines to create MySQL databases and it is supporting for MySQL 5.6 and below versions only.
I am trying to load millions of records using ETL tool-KETTLE and let us assume having 4 indexes on one of my table.
1st index is on primary key(i.e. surrogate key)
2nd index is on id
3rd index on code1
4th index on code2
1st and 2nd indexes are mandatory for me why because i am applying comparisons on id and key columns and loading millions of records, in this case both are useful.
example: select a.name,b.nam1 from table a, table b where a.id=b.id and a.key= b.key
But I want to disable index for code1 and code2 indexes why because these 2 indexes are using for reporting purpose only.
thanks,
Ra na la
Subject
Views
Written By
Posted
5411
February 12, 2016 01:26AM
1672
February 12, 2016 09:48AM
1672
February 15, 2016 06:24AM
1531
February 15, 2016 10:47AM
1581
February 15, 2016 11:17AM
1359
February 16, 2016 05:51PM
1304
February 16, 2016 11:39PM
Re: Disable single index instead of all indexes
1545
February 18, 2016 05:34AM
1224
February 20, 2016 12:00AM
1129
March 15, 2016 09:40AM
1217
March 15, 2016 08:16PM
1073
March 16, 2016 12:33AM
1182
March 16, 2016 05:04PM
1215
March 28, 2016 03:15AM
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.