Re: Slow running query

Ok, thanks for the test. you've right.   - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Monday, January 27, 2003 5:13 PM Subject: Re: Slow running query Looks to me like that hurts more than it helps...

RE: Slow running query

nuary 27, 2003 12:14 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Slow running query Looks to me like that hurts more than it helps... SQL> declare  2  v_cnt   number;  3  begin  4  for i in 1..1 loop

Re: Slow running query

AIL PROTECTED]> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, January 27, 2003 7:59 AM Subject: Re: Slow running query > first thing to do, try to use  count(a_column_name) instead of count(*)> > > > - Original Message -> To:

Re: Slow running query

first thing to do, try to use count(a_column_name) instead of count(*) - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, January 27, 2003 2:29 PM > First thought, > > Count(*) and FIRST_ROWS are self contradictory. If you want to count a

RE: Slow running query

Is F1.AMTLICHESKENNZEICHEN indexed as this seems to be the main filter? -Original Message- [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 13:04 To: Multiple recipients of list ORACLE-L Hi List: I have the below query which is taking 5 min. 20 sec. to fetch the records.

RE: Slow running query

Ranganath, Is the OR NOT EXISTS (SELECT /*+INDEX_FFS(HISTORIE, I_MYTECHOBJEKT) */ ZPAB.FAHRZEUG.OID FROM ZPAB.FAHRZEUG,ZPAB.HISTORIE WHERE ZPAB.FAHRZEUG.OID = ZPAB.HISTORIE.MYTECHOBJEKT and ZPAB.FAHRZEUG.oid=F1.oid) not just wishing to

RE: Slow running query

Access path would be helpfull. Alternatively, you can publish password for the user "SYSTEM", hostname, port and SID so that we can help you over the internet. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, January 27, 2003 8:04 AM To: Multiple recipients of list ORACLE-L

RE: Slow running query

First thought, Count(*) and FIRST_ROWS are self contradictory. If you want to count all the records, how will first_rows help? Regards Naveen -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, January 27, 2003 6:34 PM To: Multiple recipients of list ORACLE-L Hi List: