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
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
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
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,
4 matches
Mail list logo