Inserting data into local partitioned index vs global partitioned index [message #648981] |
Wed, 09 March 2016 07:32 |
sasisan09
Messages: 15 Registered: October 2010 Location: India
|
Junior Member |
|
|
Hi All,
Tried to search in the google but that did not help much.
Background:
We are trying to change a Global partitioned index to local partitioned index as our client thought its easier to maintain. However they were seeing some performance issues in some APIs (querying the tables for which the index was updated) so we reverted back to the Global partitioned index.
Question:
Now client noticed that there are couple of other API's that are seeing increased response times where we are inserting data into the tables when the partitions are reverted (from local to global). Was curious to know if this could be possible that the change in the index can impact the performance on insert. If someone could answer this it will be helpful for me to understand such considerations when doing any such changes in future.
Note: The performance when it was earlier Global partitioned index is similar to the performance when it was reverted.
Possibly the solution for this problem might be to check if we can tune the queries that were accessing the tables (with local partitioned indexes).
Regards
Sasidhar
|
|
|
|
|
|
|
|
|