Re: Speed enhancements - one select, nested select, two consecutive s elects

[Stephen Keen <Stephen_Keen@SQR-SERVICES.COM>]

All things being equal, your best performance will be from the two select
statements.  I pick number 3 and that is my final answer Regis

Stephen B. Keen

 -----Original Message-----
From:   Discussion of SQR,             Brio Technology's database reporting
language [mailto:SQR-USERS@list.iex.net]  On Behalf Of Brown, Bryan
Sent:   Monday, May 15, 2000 12:29 PM
To:     SQR-USERS@list.iex.net
Subject:        Speed enhancements - one select, nested select,             two
consecutive s elects

Good morning everyone!

Thanks to everyone's help, I managed to get my last report off the ground
finally - Thanks!

On a different report, I have an extremely slow report. I was wondering
about performance of SQRs - which is the faster approach....

1.) A select with Joined tables
2.) Nested Select (i.e. select a from b where b = (select c from....)
3.) Two select statements:
   a.) Select a from table1
   b.) Select b from table 2 where c=a.table1

Thanks,
Bryan

------------------------------------------------------------
Bryan E. Brown
bbrown2@acsalaska.com, 907-564-1303
Systems Analyst, ACS (Alaska Communication Systems)
SQRW  V3.0.13.2, CSS Hrizon ver 8, Oracle 7.3.3, NT (server & workstations)