On 28/05/2009 12:24 AM, Dan wrote: > > If a single column index is like the index found in textbooks, > a compound index with two fields is like the phone book. Sorted first by > surname, then by first name. The "rowid", if you like, is the phone > number. > > So, it's easy to find the set of phone numbers for everybody with the > surname "Jones". It's easy to find the set of phone numbers for people > called "Barry Jones". Quite difficult to find all the people called > "Barry" > though.
And even more difficult to find all the people nicknamed "Bazzer" :-) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
