> 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(at)killerbytes(dot)com
http://www.killerbytes.com/
(303) 665-7007 voice