Re: Optimizing SQL to Reduce Table Scans

ct witter wrote:
> Thanks for the response. Even without the plan any suggestions for
> improvement? Is this the proper way to conduct this kind of query?

Without the plan only a fool would give advice.

And only a fool would take it.

Don't try to shortcut doing the job correctly.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)