MySQL Forums
Forum List  »  InnoDB

Re: Disable single index instead of all indexes
Posted by: Ra Nala
Date: March 16, 2016 12:33AM

Thank you.

Why i am trying to drop and re create OR off/on is actually my report developers will run reports which is pointed to my datamart table.

Yes, i have primary key on my target table. but report developers are retrieving data based on few columns thats why i kept indexes for those columns.

So here my scenario is, indexes will be useful while retrieving the data but when i try to load data from staging area to datamart area(writing process) then there is a lot of performance impact.

Hope you understood why i want to apply off/on indexes.

Options: ReplyQuote

Written By
February 12, 2016 01:26AM
Re: Disable single index instead of all indexes
March 16, 2016 12:33AM

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.