Re: Disable single index instead of all indexes

[Ra Nala]

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