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-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 > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
