methodology can hope to
>> establish
>> > correct behaviour of the program.
>> >
>> > RB Smissaert wrote:
>> >> Poor comparison in this case.
>> >> Are you going to make a mathematical model when you got a little
>> stream
>> >> to
>> >>
viour of the program.
>>>
>>>RB Smissaert wrote:
>>>
>>>>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?
&g
ote:
> >> 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
> >>
> >>
> >>
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 fir
>>>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
>>>
>>>
>>>-Ori
e: 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 at
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
-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_
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. Any
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 inde
Ok, I guessed something like that were the case, but what I didn't get
was the purpose of the logN, without knowing the base for that. So why not
simply something like: if (N / m) > 2 then most likely index will be
helpful.
It sure is tricky to add these indexes as getting it wrong will seriously
11 matches
Mail list logo