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.
Subject
Views
Written By
Posted
5403
February 12, 2016 01:26AM
1671
February 12, 2016 09:48AM
1668
February 15, 2016 06:24AM
1531
February 15, 2016 10:47AM
1577
February 15, 2016 11:17AM
1358
February 16, 2016 05:51PM
1304
February 16, 2016 11:39PM
1544
February 18, 2016 05:34AM
1222
February 20, 2016 12:00AM
1129
March 15, 2016 09:40AM
1215
March 15, 2016 08:16PM
Re: Disable single index instead of all indexes
1073
March 16, 2016 12:33AM
1181
March 16, 2016 05:04PM
1214
March 28, 2016 03:15AM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
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.