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] -----------------------------------------------------------------------------
