On Sat, Mar 5, 2011 at 8:14 AM, BareFeetWare <list....@barefeetware.com>wrote:
> On 05/03/2011, at 1:59 AM, "J Trahair" <j.trah...@foreversoftware.co.uk> > wrote: > > > I understand about Primary keys and Unique keys attributed to their own > field. Is there a need to have other fields indexed, for faster searching? > Eg. a table containing your favourite music. Say you have 9 Beethoven > symphonies (one row in the table for each), 14 Bach partitas and 100 Haydn > symphonies, and you want to select the Bach ones. > > You have a table called AllMusic containing columns called Composer, > NameOfPiece, YearComposed, etc. > > > > SELECT * FROM AllMusic_tbl WHERE Composer = 'Bach' ORDER BY YearComposed > > Watch this talk by an author of SQLite for a great explanation in his own words: http://www.youtube.com/watch?v=Z_cX3bzkExE Eric -- Eric A. Smith There is no likelihood man can ever tap the power of the atom. -- Robert Millikan, Nobel Prize in Physics, 1923 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users