On Wed, 12 Sep 2007 18:39:02 +0800, you wrote: >Hi, > >Can anyone explain how does the below sql statmenent work, > > select * from tbl1 where a=xx and b=yy; when a is > indexed and b is indexed seperately? I tried explain > could not make out. > Does it select all records with t=111 and then do a > search for b=222 with in that set or other way?
Perhaps you will find an explanation here: http://www.sqlite.org/optoverview.html Regards, -- ( Kees Nuyt ) c[_] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
