MySQL Forums
Forum List  »  Full-Text Search

MySQL Full Text Search - So many Indexes
Posted by: Natasha na
Date: March 17, 2016 05:15AM

1) I am using XAMPP. MySQL Server version: 10.1.9-MariaDB

Table corp_news has around 10,000 rows.

I am using below query to create Index using PHPMyADmin.

ALTER TABLE corp_news ADD FULLTEXT INDEX `corp_nz` (`content` ASC, `subject` ASC);

After running this query, On left hand side menu, when i click the "index" from the tree i see many indexes named like

content2
content3
content4
.
.
.
.
content37
subject2
subject3
subject4
.
.
.
.
subject36
subject37

I thought it would create only one Index table named "corp_nz". what the heck so many index tables about? Is this normal?



2) If this is the case, how can i even drop the full text index on "corp_news" table?

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Full Text Search - So many Indexes
2573
March 17, 2016 05:15AM


Sorry, you can't reply to this topic. It has been closed.

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.