On Wed, May 27, 2009 at 12:34:00PM -0500, Jay A. Kreibich scratched on the wall: > On Wed, May 27, 2009 at 10:23:04AM -0400, D. Richard Hipp scratched on the > wall: > > Indices can be used for sorting as well as for lookup. And sometime > > content can be pulled from indices to avoid an additional search to > > find the original table entry. For these reasons, compound indices > > can be useful.
> One additional point. This is getting a bit into the nitty gritty > details, but SQLite is capable of servicing data requests directly > from indexes, if all the data is available. Duh. I guess Dr. Hipp explained that pretty clearly already. I got so focused on his sorting example (which is something I'm trying to understand more clearly) I kind of missed the bit where he already explained all this. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Our opponent is an alien starship packed with atomic bombs. We have a protractor." "I'll go home and see if I can scrounge up a ruler and a piece of string." --from Anathem by Neal Stephenson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
