Re: [sqlite] Is there always an index on ROWID?

2008-02-20 Thread Jos van den Oever
2008/2/21, Neville Franks <[EMAIL PROTECTED]>: > If I create a table with a Primary key on a TEXT clm, will there still > be an Index on the in-built ROWID clm. The reason for asking this is > that I need fast (indexed) lookup to rows by both ROWID and my TEXT > clm. According to the documenta

Re: [sqlite] Is there always an index on ROWID?

2008-02-20 Thread Neville Franks
Hi Jeff, Thanks, I thought that would be the case, but didn't want to start creating tables etc. and find I was wrong. Sorry about the spam-challenge you received. I didn't have it setup right for this list. Thursday, February 21, 2008, 11:30:51 AM, you wrote: JH> The table data is stored in a

Re: [sqlite] Is there always an index on ROWID?

2008-02-20 Thread Jeff Hamilton
The table data is stored in a b-tree keyed off of the rowid, so lookups based on rowid should always be fast. -Jeff On Wed, Feb 20, 2008 at 6:27 PM, Neville Franks <[EMAIL PROTECTED]> wrote: > Hi, > If I create a table with a Primary key on a TEXT clm, will there still > be an Index on the in-b

[sqlite] Is there always an index on ROWID?

2008-02-20 Thread Neville Franks
Hi, If I create a table with a Primary key on a TEXT clm, will there still be an Index on the in-built ROWID clm. The reason for asking this is that I need fast (indexed) lookup to rows by both ROWID and my TEXT clm. I am just starting out with SQLite and have almost finished Michael Owens book,