Fair enough. I was afraid that something rather obvious was going over my head. Fortunately, Egor had the answer you needed. :)
Edward Dudlik Becoming Digital www.becomingdigital.com ----- Original Message ----- From: "rich johnson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, 10 June, 2003 05:42 Subject: Re: Storing negative numbers in AUTO_INCREMENT >I hate to be the one to ask, but what's the subject have to do with the >rest of >the message? I can't see how the two are related at all. They are not :-( I started out using an old draft (which was never sent, because I figured it out in the meantime). Didn't want to blast away at the list once again with a "sorry, wrong subject" though... - Rich > >Edward Dudlik >Becoming Digital >www.becomingdigital.com > > >----- Original Message ----- >From: "rich johnson" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Tuesday, 10 June, 2003 04:57 >Subject: Storing negative numbers in AUTO_INCREMENT > > >Hi, > >Short question: I understand that MySQL in some circumstances >may decide that it's faster to do a full table scan rather than use >the index to look up values. > >But I miss some information on *when* this happens. Is there some >way, short of reading the source code, that one can get some more >details on this subject? > >Thanks for any answer anyone can provide... > >_________________________________________________________________ >STOP MORE SPAM with the new MSN 8 and get 2 months FREE* >http://join.msn.com/?page=features/junkmail > > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: >http://lists.mysql.com/[EMAIL PROTECTED] > > > > > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
