Re: [sqlite] SQLite join-mechanisms question

2007-04-12 Thread Cesar Rodas
Thank very very much That is the information that i was searching for! ;) On 12/04/07, Dennis Cote <[EMAIL PROTECTED]> wrote: Cesar Rodas wrote: > Thanks for the answer mister Hipp, but I am searching an SQL help. > I'd like > to know how is the SQLite join algorithm or where i could find

Re: [sqlite] SQLite join-mechanisms question

2007-04-12 Thread Dennis Cote
Cesar Rodas wrote: Thanks for the answer mister Hipp, but I am searching an SQL help. I'd like to know how is the SQLite join algorithm or where i could find it (in what ".c" file). Thank for the help! ;) Cesar, You should check out the slide show at

Re: [sqlite] SQLite join-mechanisms question

2007-04-12 Thread Cesar Rodas
On 12/04/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: "Cesar Rodas" <[EMAIL PROTECTED]> wrote: > Hello. > > I have a question about SQLite join-mechanisms. Let me explain with an > example. > > I have the follow table. > CREATE TABLE a( >word_id INTEGER, >doc_id INTEGER > ); > >

Re: [sqlite] SQLite join-mechanisms question

2007-04-12 Thread drh
"Cesar Rodas" <[EMAIL PROTECTED]> wrote: > Hello. > > I have a question about SQLite join-mechanisms. Let me explain with an > example. > > I have the follow table. > CREATE TABLE a( >word_id INTEGER, >doc_id INTEGER > ); > > CREATE INDEX "a_index1" ON "a"( > "doc_id" ASC > ); > >

Re: [sqlite] SQLite join-mechanisms question

2007-04-12 Thread Cesar Rodas
I want to know SQLite join algorithm On 12/04/07, P Kishor <[EMAIL PROTECTED]> wrote: On 4/12/07, Cesar Rodas <[EMAIL PROTECTED]> wrote: > Hello. > > I have a question about SQLite join-mechanisms. Let me explain with an > example. > > I have the follow table. > CREATE TABLE a( >word_id

Re: [sqlite] SQLite join-mechanisms question

2007-04-12 Thread P Kishor
On 4/12/07, Cesar Rodas <[EMAIL PROTECTED]> wrote: Hello. I have a question about SQLite join-mechanisms. Let me explain with an example. I have the follow table. CREATE TABLE a( word_id INTEGER, doc_id INTEGER ); CREATE INDEX "a_index1" ON "a"( "doc_id" ASC ); CREATE INDEX "a_index"

[sqlite] SQLite join-mechanisms question

2007-04-12 Thread Cesar Rodas
Hello. I have a question about SQLite join-mechanisms. Let me explain with an example. I have the follow table. CREATE TABLE a( word_id INTEGER, doc_id INTEGER ); CREATE INDEX "a_index1" ON "a"( "doc_id" ASC ); CREATE INDEX "a_index" ON a ( "word_id" DESC ); And how can SQLite do an