List:Internals« Previous MessageNext Message »
From:Krunal Bauskar Date:June 10 2008 12:10am
Subject:Re: How to restrict use of indexes in MySQL query plan
View as plain text  
Hi,

Some indexes created through DDL are only interpretable by hardware
hence we need to disable the use of these indexes at SE API level.

Regards,
Krunal

On Fri, Jun 6, 2008 at 12:57 AM, Sergei Golubchik <serg@stripped> wrote:
> Hi!
>
> On Jun 05, Krunal Bauskar wrote:
>> Hi,
>>
>> I am looking for a way using which I can disable use of indexes in
>> MySQL.
>>
>> Under some specific condition even though MySQL optimizer think that
>> index is the best possible way to evalutate the query I want to turn
>> it off so that optimizer will not generate plan with index.
>
> What is the problem you're trying to solve ?
>
> 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
>



-- 
Regards,
Krunal Bauskar
Thread
How to restrict use of indexes in MySQL query planKrunal Bauskar5 Jun
  • Re: How to restrict use of indexes in MySQL query planSergei Golubchik6 Jun
    • Re: How to restrict use of indexes in MySQL query planKrunal Bauskar10 Jun
      • Re: How to restrict use of indexes in MySQL query planSergei Golubchik10 Jun