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
