Announcement

Announcement Module
Collapse
No announcement yet.

Duplicate index if one BTREE and one FULLTEXT ?

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Duplicate index if one BTREE and one FULLTEXT ?

    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

  • #2
    No, they are different kinds of indices.

    Comment

    Working...
    X