> 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 [EMAIL PROTECTED] http://www.killerbytes.com/ (303) 665-7007 voice ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
