List:Internals« Previous MessageNext Message »
From:Sergei Golubchik Date:June 6 2008 7:57am
Subject:Re: How to restrict use of indexes in MySQL query plan
View as plain text  
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
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