mysqlindexing

What are Visible INDEX and Invisible INDEX in MySQL? Which is better?

What are Visible INDEX and Invisible INDEX in MySQL?

Which is better?

I have a database tables with about 1M rows. The previous development team doesn't add Index to the table columns. Now we need to add Index to some columns to speed up the fetch query.

Solution

  • In simple words

    Visible INDEX are working or Active Index.

    Invisible INDEX are removed Indexes, which were marked as Removed.