Re: Help with Report Design

Paul:

Thanks for the encouragement.

Unfortunately, yes -- the view works fine in sql plus.

The reason for the temporary table was to avoid a sort. If I use a select distinct, I guarantee a sort. If I make a temporary table first, then select based on that, then hopefully Oracle will use its indexes (indices?) to get to the data in the correlated subqueries.

The table of states shouldn't change very often, right? :-)

• Original Message ----- From: Paul Dorsey <pdorsey_at_dulcian.com> To: Eric Raskin <eraskin_at_paslists.com> Sent: Monday, December 06, 1999 11:13 AM Subject: Re: Help with Report Design

> First, there is no reason to build the temporary table.
> Why are you doing that?
>
> I don't know whay you are getting a visit from the good doctor.
> There is no reason that should happen.
> Can you query from the view in sql plus?
> sorry
>
> You are on the right track, don't bail and use the multiple
> queries, it will create a load of unnecessary network traffic.
>
> Paul Dorsey
> Dulcian, Inc.
> (212) 595-7223
> web address: http://www.dulcian.com
> email: pdorsey_at_dulcian.com
>
Received on Mon Dec 06 1999 - 17:33:10 CET