What is faster?

From: "Mihai Gheorghiu" <tanethq(at)earthlink(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: What is faster?
Date: 2001-09-17 16:19:04
Message-ID: 001401c13f94$7b7290e0$6e646464@New6.Travel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

What runs faster?
select where timestamp IS NOT NULL
or
select where boolean IS TRUE?
Does it make a significant difference if the boolean is indexed? There are
many records in the table.

Thank you for your help.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2001-09-17 17:20:17 Re: adding a superuser
Previous Message Doug Moore 2001-09-17 16:08:17 read in to psql from file