On Tue, Jun 29, 2004 at 01:37:30 -0700,
  Chris Cheston <[EMAIL PROTECTED]> wrote:
> ok i just vacuumed it and it's taking slightly longer now to execute
> (only about 8 ms longer, to around 701 ms).
> Not using indexes for calllogs(from)... should I?  The values for
> calllogs(from) are not unique (sorry if I'm misunderstanding your
> point).

If you are hoping for some other plan than a sequential scan through
all of the records you are going to need an index. You can have an
index on a column (or function) that isn't unique for all rows.

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

Reply via email to