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