Re: DECODE

David,

> >  I regularly use queries and views that involve 6-9 tables,
> > three UNIONS, and two sub-selects in each UNION ... and still get a
> 2-3
> > second response time on the 500mhz Celeron production machine.
>
> Thanks.  Good advice.
> Question: How big are those tables you're joining and uniting?  (disk
> size, and number of rows).

I'm not sure about disk size.  Some of the tables are reference lists,
with just a few dozen rows.  4 of the tables have at least 1000 rows
each.  Nothing large, or I'd use a faster processor.

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco