> The time the DB needs to find the record > should be the same since the record has to be found before the resultset is > assembled. What if the query can be satisfied from an index? I don't know if PostgreSQL has this kind of optimization or not. But in the original example: select id, updated_date from customers limit 100 Sybase, for instance, would not use table pages at all if there were an index covering id & updated_date. -- Scott Ribe scott_ribe@xxxxxxxxxxxxxxx http://www.killerbytes.com/ (303) 665-7007 voice
