Re: bad performance

Does this occur with all SQL queries ? If so, I think your pagesize parameter is set to 200 and you have pause on.

Try:

SQL> set pagesize 0;
SQL> set pause off;

Sbaiz wrote:
>
> I'm using Oracle 7.3 on Unix 4.0B platform with 512Mb RAM.
>
> I perform the follow select for SQLPlus:
>
> SQL>SELECT DISTINCT "CUSTOMERS"."CUSTOMER_ID"||' -
> '||"CUSTOMERS"."CUSTOMER_NAME",
> "CUSTOMERS"."CUSTOMER_ID",
> "CUSTOMERS"."CUSTOMER_NAME"
> FROM "CUSTOMERS",
> "ORGANIZATION_STRUCTURE_NODES"
> WHERE ( "ORGANIZATION_STRUCTURE_NODES"."CUSTOMER_ID" =
> "CUSTOMERS"."CUSTOMER_ID" )
> ORDER BY "CUSTOMERS"."CUSTOMER_ID" ASC ;
>

       The contents of this message express only the sender's opinion.
       This message does not necessarily reflect the policy or views of
       my employer, Merck & Co., Inc.  All responsibility for the statements
       made in this Usenet posting resides solely and completely with the
       sender.