> On Jun 20, 2004, at 9:07 PM, Darren Duncan wrote: <snip>
> down the result set would make things faster..? Wouldn't the select > here: > > CREATE TABLE tmp ( flag boolean, name text ); > > SELECT name FROM tmp WHERE flag = 1 AND name LIKE '%foo%'; > > run faster with an index on the flag column since it can scan > just the > flag = 1 rows instead of the full table? I think this is one of those big-O things, right? It might be faster, but only a bit faster, and not enough to justify the hassle of creating and maintaining the index. --Keith --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
