# Toad for Oracle compare   index comparison

**URL:** <https://forums.toadworld.com/t/toad-for-oracle-compare-index-comparison/39794>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [August 2, 2017, 8:00am UTC](https://forums.toadworld.com/t/toad-for-oracle-compare-index-comparison/39794 "2017-08-02T08:00:19Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![rdrechsler](https://avatars.discourse-cdn.com/v4/letter/r/3e96dc/32.png) [@rdrechsler](https://forums.toadworld.com/u/rdrechsler)\
**Post date:** [August 2, 2017, 8:00am UTC](https://forums.toadworld.com/t/toad-for-oracle-compare-index-comparison/39794/1 "2017-08-02T08:00:19Z")

</div>

Ok, this has occured in multiple versions since I started using Toad for Oracle Base edition.

Why does compare not recognize that indexes in different systems are the same but have different names and thus generate a rename command? Instead, it generates a drop index and then a create index which for very large tables may not be feasible?

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [August 2, 2017, 8:15am UTC](https://forums.toadworld.com/t/toad-for-oracle-compare-index-comparison/39794/2 "2017-08-02T08:15:02Z")

</div>

That would be a nice enhancement. I’ll work on it.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [August 2, 2017, 8:44am UTC](https://forums.toadworld.com/t/toad-for-oracle-compare-index-comparison/39794/3 "2017-08-02T08:44:01Z")

</div>

Actually, it looks like we already do that for indexes that are part of a PK or Unique constraint. I just need to extend the functionality to non-unique indexes.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [August 2, 2017, 10:17am UTC](https://forums.toadworld.com/t/toad-for-oracle-compare-index-comparison/39794/4 "2017-08-02T10:17:28Z")

</div>

OK, Next beta, non-unique indexes that differ by name will be renamed instead of rebuilt.

---

<div class="post-metadata">

**Author:** ![rdrechsler](https://avatars.discourse-cdn.com/v4/letter/r/3e96dc/32.png) [@rdrechsler](https://forums.toadworld.com/u/rdrechsler)\
**Post date:** [August 3, 2017, 7:51am UTC](https://forums.toadworld.com/t/toad-for-oracle-compare-index-comparison/39794/5 "2017-08-03T07:51:37Z")

</div>

John, yes, I should have mentioned it was non primary key indexes… but thanks for including the enhancement.