Re: Forcing query to use an index

On Monday, Mar 3, 2003, at 15:32 US/Pacific, Josh Berkus wrote:
> Check out the thread: Re: [SQL] OUTER JOIN with filter
> in today's list; this relates to your problem. Then try your query as:

I'll read through this, thank you.

> LEFT OUTER JOIN (SELECT * FROM Customer_Month_Summary
> WHRE CMS.MonthStart = DATE '2003-02-01'
> ) CMS ON C.ID = CMS.CustomerID

This works beautifully! Thanks.

> This set of expressions has "seq scan" written all over it. I hihgly
> suggest
> that you try to find a way to turn these into anchored text searches,
> perhaps
> using functional indexes on lower(column).

Hmm, I'll have to give this one some thought, since it looks like there
won't be any easy way to index those text columns, since the text I'm
searching for could be anywhere within the column.

Thank you everyone for all the help!