SELECT * FROM t where p or q;

From: frbn(at)efbs-seafrigo(dot)fr
To: pgsql-sql(at)postgresql(dot)org
Subject: SELECT * FROM t where p or q;
Date: 2001-11-16 13:40:52
Message-ID: 3BF51764.8BEAC873@efbs-seafrigo.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-11-16 15:43:25 Re: between syntax
Previous Message Markus Bertheau 2001-11-16 11:41:31 between syntax