Re: How to restrict use of indexes in MySQL query plan

[Sergei Golubchik]

Hi!

On Jun 09, Krunal Bauskar wrote:
> 
> Some indexes created through DDL are only interpretable by hardware
> hence we need to disable the use of these indexes at SE API level.

In ::open() method you set table->s->keys_in_use to include only
keys you want MySQL to use.

Regards / Mit vielen Grüssen,
Sergei

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <serg@stripped>
 / /|_/ / // /\ \/ /_/ / /__  Principal Software Engineer/Server Architect
/_/  /_/\_, /___/\___\_\___/  Sun Microsystems GmbH, HRB München 161028
       <___/                  Sonnenallee 1, 85551 Kirchheim-Heimstetten
Geschäftsführer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Häring