In the relational model, the unit of access is a tuple so you would expect a DBMS to process all columns. Typically they also access in units of a page (although a tuple of course might extend across more than one page)
The discussion seems to have moved onto selecting pages. Surely if you need to do this, stick an index on the column concerned. The index's purpose is to take you directly to the target page. -- View this message in context: http://www.nabble.com/Sqlite-reading-all-column-data-on-selects.-tp25594620p25641328.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users