Poor comparison in this case. Are you going to make a mathematical model when you got a little stream to cross and you have a few available planks to do it?
RBS -----Original Message----- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: 05 August 2007 16:43 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Re: Re: Re: Re: Re: Re: Re: How does SQLite choose the index? We learn mathematics etc so that we can make numerical models which give us design information. Imagine trying to build every combination of a bridge to settle on a design! Make a mathematical model and get it close to optimal at the first attempt. RB Smissaert wrote: > Yes, I suppose you are right there. > I will see if I can put together a report that runs all possible types of > queries (sequentially) and then see if I have left anything out that would > cause problems. > > RBS > > > -----Original Message----- > From: Gerry Snyder [mailto:[EMAIL PROTECTED] > Sent: 05 August 2007 03:35 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Re: Re: Re: Re: Re: Re: Re: How does SQLite choose the > index? > > RB Smissaert wrote: > >>.... I think an application that >>would produce all the needed indexes based on the table and all the > > possible > >>queries would be helpful. Anybody done such an app? > > _All_ possible queries? Not practical for any significant number of > columns. N factorial gets big fast. > > The indexes would be much larger than the data base itself. > > I'm afraid you are going to have to settle for doing an intelligent > design of the data base. > > > Gerry > > > ---------------------------------------------------------------------------- > - > To unsubscribe, send email to [EMAIL PROTECTED] > ---------------------------------------------------------------------------- > - > > > > > ---------------------------------------------------------------------------- - > To unsubscribe, send email to [EMAIL PROTECTED] > ---------------------------------------------------------------------------- - > ---------------------------------------------------------------------------- - To unsubscribe, send email to [EMAIL PROTECTED] ---------------------------------------------------------------------------- - ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------