can u please show me the explain plan for this sql and also the table structure
explain select statement desc table_name On 11/10/08, Alex K <[EMAIL PROTECTED]> wrote: > > Hi Ananda, > > Indexes are present. I'm passing no more 10 values. > > Alex > > 2008/11/10 Ananda Kumar <[EMAIL PROTECTED]>: > > it should not cause any issues, unless your passing too many values in > "id > > in(1,2,...n). > > Are the indexes present. > > > > > > On 11/10/08, Alex K <[EMAIL PROTECTED]> wrote: > >> > >> Hello, > >> > >> It seems to me that the statement "id in (id1, id2 ... idn)" is much > >> slower than "id=id1 or id=id2 ... or id=idn" or I am doing something > >> wrong? > >> > >> Thank you, > >> > >> Alex > >> > >> -- > >> MySQL General Mailing List > >> For list archives: http://lists.mysql.com/mysql > >> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >> > >> > > >
