Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAGE7qm29727 for ; Fri, 16 Nov 2001 09:07:52 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id fAGDemV88393 for pgsql-sql@postgresql.org; Fri, 16 Nov 2001 08:40:48 -0500 (EST) (envelope-from news) From: frbn@efbs-seafrigo.fr X-Newsgroups: comp.databases.postgresql.sql Subject: SELECT * FROM t where p or q; Date: Fri, 16 Nov 2001 14:40:52 +0100 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 17 Message-ID: <3BF51764.8BEAC873@efbs-seafrigo.fr> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: scrappy@hub.org X-Mailer: Mozilla 4.7 [fr] (Win98; I) X-Accept-Language: fr To: pgsql-sql@postgresql.org X-Archive-Number: 200111/279 X-Sequence-Number: 5661 hi, on a +10 millions rec table, a simple select: SELECT * FROM tab where num = x; time: 5 secondes SELECT * FROM tab where num = y; time: 5 secondes SELECT * FROM tab WHERE num = x OR num = y; time: more than 10 mn !!! num is an integer.