MariaDB Inner join is slow

2 votes

1 answer

1861 views

execution-plan performance mariadb-10.3 performance-tuning

                          Here is my SQL (with explain):

    EXPLAIN
    SELECT * FROM
    GBI gbi
    INNER JOIN VF_KRED kred ON
    	gbi.vendor = kred.vendor;

Giving below the outcome:

Now, the select SQL takes ~10 seconds to produce the outcome.

Below are the indexes on tables:

- VF_KRED table:

- GBI table:

Any clues?

Asked by Akshay Lokur (121 rep)

Jun 25, 2019, 04:06 PM
Last activity: Aug 5, 2025, 04:05 PM

MariaDB Inner join is slow

Related Questions