Re: SELECT statement efficiency question

On Sun, 08 Apr 2007 00:30:14 -0500, Dereck L. Dietz wrote:

> This is a data warehouse load. The input source has some rows with
> "DATA" and "CORRECTION" in the name fields which indicate there needs to
> be a data correction and also that those rows are NOT to be loaded into
> the tables.

May be a flag column defined like this:

should_load char(1) default 'Y' check (col1 in ('Y','N'))

would serve you better then the convention with names that you currently use?

-- 
http://www.mladen-gogala.com