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