# Duplicate index if one BTREE and one FULLTEXT ?

**URL:** <https://forums.percona.com/t/duplicate-index-if-one-btree-and-one-fulltext/1490>\
**Category:** Other MySQL® Questions\
**Created:** [August 31, 2010, 9:06am UTC](https://forums.percona.com/t/duplicate-index-if-one-btree-and-one-fulltext/1490 "2010-08-31T09:06:42Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![micromatikal](https://avatars.discourse-cdn.com/v4/letter/m/49beb7/32.png) [@micromatikal](https://forums.percona.com/u/micromatikal)\
**Post date:** [August 31, 2010, 9:06am UTC](https://forums.percona.com/t/duplicate-index-if-one-btree-and-one-fulltext/1490/1 "2010-08-31T09:06:42Z")

</div>

Wondering if it is indeed a duplicate index when one is a BTREE index and one is a FULLTEXT index such as the following example:

| partall | 1 | partkey | 1 | partkey | A | 9001334 | NULL | NULL | | BTREE

| partall | 1 | partsno\_2 | 1 | partkey | NULL | 9001334 | NULL | NULL | | FULLTEXT  
| partall | 1 | partsno\_2 | 2 | clei | NULL | 9001334 | NULL | NULL | | FULLTEXT

In the above example can I eliminate the partkey BTREE index since it is covered by the partsno\_2 “compound” FULLTEXT index?

Thanks  
Tim

---

<div class="post-metadata">

**Author:** ![gmouse](https://avatars.discourse-cdn.com/v4/letter/g/b9e5f3/32.png) [@gmouse](https://forums.percona.com/u/gmouse)\
**Post date:** [September 2, 2010, 4:18am UTC](https://forums.percona.com/t/duplicate-index-if-one-btree-and-one-fulltext/1490/2 "2010-09-02T04:18:38Z")

</div>

No, they are different kinds of indices.