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 b-tree keyed off of the rowid, so JH> lookups based on rowid should always be fast. JH> -Jeff JH> 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-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, but have been unable to find an answer to this. >> >> Thanks. >> >> -- >> Best regards, >> Neville Franks, Author of Surfulater - Your off-line Digital Reference >> Library >> Soft As It Gets Pty Ltd, http://www.surfulater.com - Download your copy >> now. >> Victoria, Australia Blog: http://blog.surfulater.com >> >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> -- Best regards, Neville Franks, Author of Surfulater - Your off-line Digital Reference Library Soft As It Gets Pty Ltd, http://www.surfulater.com - Download your copy now. Victoria, Australia Blog: http://blog.surfulater.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users