Subject: Combining two bitmap scans out performs a single regular index scan?
From: tgl@sss.pgh.pa.us (Tom Lane)
Date: 12/8/2007 3:46:19 PM
Mark Mielke <mark@mark.mielke.cc> writes:
> To find records after a certain time, I must do one of:
> select * from icpric where audtdate > ? or (audtdate = ? and
> audttime > ?)
In recent releases (at least 8.2, don't remember about 8.1), a row
comparison is what you want:
WHERE (auddate, adttime) > (?, ?)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
|